How to Move the SCVMM 2008 R2 Database to Another Server

How to Move the SCVMM 2008 R2 Database to Another Server

Note: This article is based on VMM 2008  and might not apply to VMM 2012 (R2)

You might find yourself in the position of needing to move the SCVMM database from one server to another for various reasons. For instance, this situation can occur when moving from local to remote SQL or from a stand-alone SQL server to a SQL cluster. The following instructions are provided as a guideline on how to accomplish this move from a SCVMM perspective.

Important!  It is strongly encouraged that before undertaking this process that a complete backup of the SCVMM database is captured.

There are two methods to accomplish the task of backing up and moving the SQL database. You can use either SQL Server Management Studio or the built in scvmmrecover.exe tool built into SCVMM.

Method #1 -- Using SQL Server Management Studio

How to move SCVMM database to another server (local to remote SQL)

1. Take a backup of the existing VMM DB

2. Uninstall VMM with the Retain Data option

3. On the remote SQL server, import VMM db

4. Install VMM pointing at the new SQL server and using the imported VMM db

5. If any managed host has the status of Access Denied, right click and select Reassociate

Method #2 -- Using the scvmmrecover.exe tool

The scvmmrecover.exe tool is discussed in great detail at the following TechNet article:  http://technet.microsoft.com/en-us/library/cc956045.aspx


Community Resources

Note: This information was originally provided by Mike Briggs, Senior Support Escalation Engineer, on the System Center Virtual Machine Manager Team blog:

http://blogs.technet.com/scvmm/archive/2010/02/01/how-to-move-the-scvmm-database-to-another-server.aspx



Other Languages

Leave a Comment
  • Please add 8 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Danny van Dam edited Revision 8. Comment: added note that this might not apply to VMM 2012 (R2)

  • Carsten Siemens edited Revision 7. Comment: Added tag: en-US

  • Danny van Dam edited Revision 6. Comment: added vmm server version to title  

  • yottun8 edited Revision 4. Comment: Added "Other Languages".

Page 1 of 1 (4 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • yottun8 edited Revision 4. Comment: Added "Other Languages".

  • Danny van Dam edited Revision 6. Comment: added vmm server version to title  

  • Carsten Siemens edited Revision 7. Comment: Added tag: en-US

  • Danny van Dam edited Revision 8. Comment: added note that this might not apply to VMM 2012 (R2)

Page 1 of 1 (4 items)