Database Recovery in Service Manager
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager
To restore a database (which includes the encryption keys) for System Center 2012 – Service Manager, you rebuild a new computer using the same computer names and instance names as the original. Your disaster recovery strategy for the Service Manager databases should be based on general procedures for SQL Server 2008 disaster recovery. For more information, see SQL Server 2008 R2 Books Online: Planning for Disaster Recovery. Remember that if you restore a database, you must give the new computer the same name as the original computer and use the same instance name as the original instance.
In addition, you must use the script that you created in the Backing Up Unsealed Management Packs in Service Manager section in this guide. You use this script to restore permissions for the recreated database.
Long-term historical data is stored in the Service Manager data warehouse and the current snapshot of the system is stored in the Service Manager database. Recreating the Service Manager data warehouse databases should only be used as a measure of last resort. When possible, you should try to restore the Service Manager data warehouse databases from backups and avoid recreating those databases. If reinstalled, the newly created Service Manager data warehouse databases will be able to synchronize the current snapshot of the system from the Service Manager database—however, historical data will be lost.