Maintaining the MIIS 2003 Database
Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2
This topic provides basic guidelines for monitoring and backing up your Microsoft® Identity Integration Server 2003 database. Because MIIS 2003 uses Microsoft® SQL Server™ 2000 for database services and storage, this topic contains information about SQL Server 2000 in addition to information about MIIS 2003.
In This White Paper
Overview of Maintaining MIIS 2003
Overview of the SQL Server 2000 Implementation for MIIS 2003
Configuring SQL Server 2000 to Support MIIS 2003
SQL Server 2000 Databases Used by MIIS 2003
SQL Server 2000 Backup Types and Recovery Models
Backup Strategies for Your MIIS Database
Scheduling Full Database Backups by Using the Database Maintenance Plan Wizard
Scheduling Differential Database Backups by Using SQL Server Enterprise Manager
Scheduling Backups of the System Databases
Backing Up the MIIS 2003 Encryption Key
Recommendations for Backing Up and Restoring the MIIS Database
Ensuring Failover and High Availability
Establishing a Performance Baseline
Setting Alerts to Monitor System Events