Backup Strategies for Your MIIS Database
Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2
You need to establish and document a backup and restore plan for your MIIS 2003 database, being sure to thoroughly test your plan in a simulation of your production environment.
Note
For more information about developing backup and restore plans for SQL Server databases, see “Chapter 3 – Backing Up and Restoring Databases” on the Microsoft TechNet Web site at https://go.microsoft.com/fwlink/?LinkID=15117.
Unless specified otherwise, this section provides instructions for using the Simple Recovery model, which is the default recovery model for MIIS 2003.
For information about backing up the SQL Server 2000 databases when you are using the Full Recovery or Bulk-Logged Recovery models, see “Backing Up and Restoring Databases” on the Microsoft MSDN Web site at https://go.microsoft.com/fwlink/?LinkID=10575.
Table 3 lists the recommended backup activities that are necessary to ensure the recoverability of your MIIS database, including the back up frequency for each.
Table 3 Recommended Backup Activities
| Backup Activity | When You Install | Intraday | Daily | Monthly | Quarterly |
|---|---|---|---|---|---|
Create a backup device. |
X |
||||
Determine an offsite storage location for your backups. |
X |
||||
Determine and document your backup procedures. |
X |
||||
Perform differential backups. |
X |
||||
Perform transaction log backups. |
X |
||||
Automatically shrink unused database file space. |
X |
||||
Perform full database backups. |
X |
||||
Back up the MIIS 2003 encryption keys. |
X |
||||
Back up the master and msdb system databases in SQL Server. |
X |
||||
Back up the entire MIIS 2003 installation. |
X |
||||
Back up the entire SQL Server 2000 installation. |
X |
||||
Perform a test recovery of your data in a test environment by using your production backups. |
X |
||||
Review your backup procedures and amend as necessary |
X |
Note
If your SQL Server implementation also contains other databases that are used by MIIS 2003 or other applications, be certain to develop a backup and restore plan that includes those databases. For a more detailed administrative schedule for SQL Server 2000, see the SQL Server 2000 Operations Guide on the Microsoft TechNet Web site at https://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx.
Backing up your MIIS database involves first creating a backup device within SQL Server 2000 and then implementing your database backup plan. Finally, you must back up the MIIS 2003 encryption keys. You can back up SQL Server 2000 databases by using the Database Maintenance Plan Wizard or SQL Server Enterprise Manager.