Recently I had an opportunity to upgrade a service manager 2010 sp1 environment to 2012 Sp1, easy right?…Right? Okay so there may be some challenges, but people like Travis Wright make the world of Service Manager easier. As many of us know the Service Manager Team Blog is a wealth of knowledge. One such nugget of information is the Moving the Service Manager Database Blog Post where much of the information I was looking for was found.
Here are the high-level steps…
1. Gather the Service Manager Management Group Name and SQL Server Database Server Name.
2. Stop Service Manager Services on the Management Servers and the Data Warehouse Server
3. Stop the Website and the Application Pool on the Server hosting the Self Service Portal
4. Back up the ServiceManager database on the old SQL Server.
5. Take the ServiceManager database offline on the old SQL Server.
6. Restore the ServiceManager database on the new SQL server.
7. Prepare the ServiceManager database on the new database server
8. Update management servers with the new database server name.
9. Back up the DWStagingandConfig database
10. Update the DWStagingandConfig database.
11. Start Service Manager Services on the Management Servers and Data Warehouse Server
12. Start the Website and Application Pool on the server hosting the Self Service Portal
In the coming weeks I’ll detail some of the gotcha’s with the move and the SCSM 2010 SP1 on SQL 2008 to SCSM 2012 SP1 on SQL 2008R2 SP1 upgrade process.