How to Move a VMM Database to Another Computer as Part of a VMM Upgrade
Updated: May 13, 2016
Applies To: System Center 2012 SP1 - Virtual Machine Manager
This topic tells how to move a VMM database as part of an upgrade to VMM in System Center 2012 SP1. For information about moving a VMM database when you're not upgrading, see How to Move a VMM Database to Another Computer.
You must move the Virtual Machine Manager (VMM) database before upgrading to System Center 2012 Service Pack 1 (SP1) in the following cases:
The VMM database is using a version of Microsoft SQL Server that is not supported by System Center 2012 SP1. For information about supported Microsoft SQL Server versions, see System Requirements: VMM Database in System Center 2012 and in System Center 2012 SP1.
The VMM database is installed on the same computer as the VMM management server and you plan to upgrade to a highly available VMM management server.
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.
To locate information about the VMM database
Open the Settings workspace.
In the Settings pane, expand General, and then double-click Database Connection.
To move a VMM database as part of a VMM upgrade
Back up your existing VMM database using the tools that are available in Microsoft SQL Server.
Copy the database backup to a computer that is running a supported version of SQL Server.
Use the tools that are available in SQL Server to restore the database.
For more information about moving a SQL Server database, see Copying Databases with Backup and Restore.