Saturday, May 7, 2011

Move the database in Service Manager 2010

2010-10-16 16:30:00Stefan Allansson

Move the database in Service Manager 2010

If you want to move the SQL database for SCSM to another SQL server, you can do like this:
Start with taking backup of your SCSM database on the first SQL server. 
In SQL server Manager, right click the Service Manager database and choose Tasks\Backup. 
Default choices are ok.
Backup DB SCSM2010
Copy the database backup file to your new SQL server. You can put the file where you want on the server. Open the SQL Manager on the new SQL server and right click “Databases” and choose Restore Database. Fill in the database name and choose “from device” and specify the location for the backup file that you have copied to the new SQL server.
Restore DB SCSM2010
Next step is to do some changes in the registry on the Service Manager Management Server. 
Change the “DatabaseServerName” to your new SQL server under:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2010\Common\Database
If you have changed the name on your database when you restored it on the new server you have to change the “DatabaseName” in the registry. Restart the service “System Center Data Access Service” on the Service Manager Management Server and then open the SCSM console. 
Now your Console is connected to your new SQL server.

1 comment:

  1. This did not work for me running CU3, I could see that the SCSM service account was connecting to SQL but the Management Server was reporting errors with the Data Access Service