How to move SCVMM database to another server

You may 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. There’re two methods to accomplish the task of backing up […]

You may 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. There’re 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: 1. backup existing VMM DB 2. Uninstall VMM with Retain Data option 3. On remote SQL server, import VMM db 4. Install VMM pointing at new SQL server and using 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, refer TechNet article.

More info: How to: Attach a Database (SQL Server Management Studio) | How to: Attach a Database File to SQL Server Express | SCVMM R2 operations Guide

[Source]