How to Move a VMM Database to Another Computer as Part of a VMM Upgrade
Updated: May 13, 2016
Applies To: System Center 2012 - Virtual Machine Manager
This topic tells how to move a VMM database as part of an upgrade to VMM in System Center 2012. For information about moving a VMM database when you're not upgrading, see How to Move a VMM Database to Another Computer.
In the following cases, you must move the VMM database before you upgrade to System Center 2012 – Virtual Machine Manager:
The VMM database uses a version of Microsoft SQL Server that is not supported by System Center 2012 – Virtual Machine Manager.
The VMM database is installed on the same computer as the VMM server and you plan to upgrade to a highly available VMM management server.
If you must move the VMM database, you cannot perform an in-place upgrade of your VMM 2008 R2 SP1 environment. For more information about how to upgrade to System Center 2012 – Virtual Machine Manager in these situations, see How to Upgrade to VMM on a Different Computer.
Use the following procedures to locate information about the VMM database such as the database name and instance name, and to move the VMM database if necessary.
Open the Settings workspace.
In the Settings pane, expand General, and then double-click Database Connection.
Back up your existing VMM database using tools that are available in SQL Server.
Copy the database backup files to a computer that is running a supported version of SQL Server.
Restore the database by using tools that are available in SQL Server.
For more information about moving a SQL Server database, see Copying Databases with Backup and Restore.