Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Moving the VMware vCenter Server 4.x/5.x/6.0.x SQL database (7960893)

Details

This article provides the steps to relocate the SQL database that is used by VirtualCenter/vCenter Server.

Solution

To move SQL Server databases used by vCenter Server to a new location:
  1. Stop the VMware VirtualCenter Server, VMware VirtualCenter Management Webservices and VMware Update Manager services. For more information, see Stopping, starting, or restarting vCenter services (1003895) and Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).

    Note: For vCenter Server 5.0.x, stop the vCenter Inventory Service and VMware vSphere Profile-Driven Storage service.

  2. Migrate the VCDB and UMDB from the existing SQL instance to the new SQL instance running on the remote server. For more information on migrating databases, see Back Up and Move a Local vCenter Server Database section in vSphere 5.0 Upgrade guide.

    Note: For vCenter Server 5.1, you will also need to migrate the vCenter Single Sign-On RSA database. For more information, see Updating the vCenter Single Sign-On server database configuration (2045528).

  3. If migrating a vCenter Server 4.x local database, you may also need to migrate the ADAM database. For more information, see Manually backing up and restoring the vCenter Server 4.x and 5.0 ADAM instance data (1029864).

  4. Note the credentials and server that vCenter Server uses to connect to the database. Update the DSN as necessary to the migrated database. For more information, see vCenter Server installation fails with ODBC and DNS errors (1003928).

  5. Recreate SQL Agent rollup jobs. Detaching, attaching, importing, and restoring a database to a newer version of SQL Server does not automatically recreate these jobs. For more information, see Updating rollup jobs after the error: Performance data is currently not available for this entity (1004382).

    Note: SQL Server Agent is not available in Microsoft SQL Server 2005 and 2008 Express.

    For a complete list of the jobs that should be present, see:

  6. Update the vcdb.properties file with the new SQL server. If this is not updated, the performance overview charts and the Storage Monitoring Service (SMS) may be affected after migrating the vCenter Server database. For more information, see JDBC URL Formats for the vCenter Server Database section in the vSphere Installation and Setup guide. The vcdb.properties file is located at:

    For vCenter Server 5.5 and below:

    • Windows 2008 – C:\ProgramData\VMware\VMware VirtualCenter
    • Other Windows versions – C:\Documents and Settings\All Users\Application Data\VMware\VMware VirtualCenter\

    For vCenter Server 6.0:

    C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx

  7. Start the VMware VirtualCenter Server and VMware Update Manager services. For more information, see Stopping, starting, or restarting vCenter services (1003895) and Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).

    Note: In vCenter Server 5.1 and above, ensure that the Single Sign-On Service is started before starting the VMware VirtualCenter Server service.
For more information on:
  • Attaching and detaching a database for Microsoft SQL Server, see Microsoft Knowledge Base article 224071.
  • Using the Copy Database Wizard in SQL Server 2000, see Microsoft Knowledge Base article 274463.
  • Syntax or best practices, engage the third-party vendor's documentation or support.
  • Moving SQL Server 2008 R2, see the MSDN article on Moving Database Files.
Note: The preceding links were correct as of October 9, 2013. If you find a link is broken, provide feedback and a VMware employee will update the link.

Additional Information

For translated versions of this article, see:

Update History

02/27/2012 - Added links to KBs 1033588, 1033587, 1029824, and 2006097 02/29/2012 - Added link to KB 1006482 01/15/2012 - Added vCenter Server 5.1 to Products and added link to KB 2033096 03/21/2013 - Added link to article 1015223 10/08/2013 - Updated link to KB 2033096

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 107 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 107 Ratings
Actions
KB: