Backing Up Service Manager 2010 SP1 Databases

  • Article

Applies To: System Center Service Manager 2010 SP1

There are up to five databases in a System Center Service Manager 2010 Service Pack 1 (SP1) environment:

  • ServiceManager

  • DWDataMart

  • DWRepository

  • DWStagingAndConfig

  • ReportServer

The first four databases in this list need to connect and exchange data with the Service Manager and data warehouse management servers. Data is encrypted during these exchanges. On the management servers, the encryption keys are backed up and restored as necessary as explained in this guide. For more information about the encryption keys on the management servers, see Backing Up Service Manager 2010 SP1 Management Servers. For the servers hosting a database, the encryption keys are stored in the databases themselves.

If a computer hosting a database fails, all that is needed is the ability to restore the databases (which include the encryption keys) to a computer with the same name as the original computer. Your disaster recovery strategy for the Service Manager databases should be based on general SQL Server 2008 disaster recovery procedures. For more information, see SQL Server 2008 Books Online: Planning for Disaster Recovery (https://go.microsoft.com/fwlink/?LinkId=131016).

As part of your disaster recovery preparation, you will need to run a script to capture the Security log to preserve user role information for each database. After you deploy Service Manager and if necessary, run the Data Warehouse Registration Wizard. You will use the SQL Server Script Wizard to create a script that captures SQL Server logon and object level permissions. Then, if you need to restore a new server for the Service Manager databases, you can use this script to recreate the necessary logon and object level permissions needed. The wizard used to generate scripts in SQL Server 2008 differs from the wizard in SQL Server 2008 R2. Instructions for both SQL Server 2008 and SQL Server 2008 R2 are presented in this guide.

Enable Common Language Runtime on SQL Server

During installation of the Service Manager database, Service Manager setup enables common language runtime (CLR) on the SQL Server. If you restore a Service Manager database to another SQL Server, you will need to manually enable CLR.

For more information see the TechNet article Enabling CLR Integration (https://go.microsoft.com/fwlink/?LinkId=217932).

In This Section

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.