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.