Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

How to Move a VMM Database to Another Computer

Updated: November 1, 2013

Applies To: System Center 2012 - Virtual Machine Manager

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.

noteNote
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.

To move a VMM database

  1. Back up your existing VMM database using tools that are available in SQL Server.

  2. Copy the database backup files to a computer that is running a supported version of SQL Server.

  3. 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.

To locate information about the VMM database

  1. Open the Settings workspace.

  2. In the Settings pane, expand General.

  3. In the Settings pane, double-click Database Connection.

For more information about moving a SQL Server database, see Copying Databases with Backup and Restore.

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.