Search the VMware Knowledge Base (KB)
View by Article ID

Backing up the vCenter Server database running on Microsoft SQL or SQL Express server (2012138)

  • 26 Ratings
Language Editions

Purpose

This article provides steps to back up the vCenter Server database running on Microsoft SQL or SQL Express server as a regular maintenance task.

Resolution

To back up the vCenter Server database:
  1. Download and install Microsoft SQL Server Management Studio Express.

    To download Microsoft SQL Server Management Studio Express, see these Microsoft Download locations:

  2. Open SQL Server Management Studio Express and connect to the vCenter Server database server or instance.

    Note: If you are not using a dedicated SQL server, the database resides on vCenter Server. To verify the location and database name:

    1. Open the ODBC connector.
    2. Click the System DSN tab.
    3. Find the vCenter Server item.
    4. Click configure.
    5. Proceed through the steps and note the SQL Server and the default database.

  3. Stop all vCenter Server services on the vCenter Server system. This ensures that no service is out of sync during the backup. For more information, see Stopping, starting, or restarting vCenter services (1003895).
  4. Expand Databases and look for the vCenter Server database, usually named as VIM_VCDB, unless you renamed it during the initial creation.
  5. Right-click the vCenter Server database and Click Tasks > Back Up.
  6. Select your backup options and Click OK.
  7. Copy the backup file to a safe location during maintenance or upgrades. Ensure to perform this backup before performing any operation on vCenter Server, as it holds current and historical data.
  8. Start all vCenter Server services on the vCenter Server system once the backup has completed. For more information, see Stopping, starting, or restarting vCenter services (1003895).

See Also

Update History

10/31/2016 - Added vCenter Server 6.5 Pre-release 01/30/2013 - Added vCenter Server 5.1.x to Products

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

  • 26 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)




Please enter the Captcha code before clicking Submit.
  • 26 Ratings
Actions
KB: