This sample procedure illustrates how to use Microsoft SQL Server Management Studio to restore a database using Win2008 R2 SP1.

About this task

This example procedure is provided for reference purposes only. Your restore procedure may vary. For information about when to use this sample procedure, see Replacing the Target vRealize Automation Database with the Source vCloud Automation Center 5.2 Database.

Prerequisites

  1. Shut down the source vCloud Automation Center 5.2 services. Do not shut down the Model Manager Web Service.

  2. Back up the vCloud Automation Center 5.2 database, for example DB52.

  3. Shut down the target vRealize Automation services. Do not shut down the Model Manager Web Service.

  4. Back up the target vRealize Automation database, for example DB62.

  5. Log in to Windows using your Domain or SQL administrator credentials.

Procedure

  1. In Microsoft SQL Server Management Studio, right-click the DB62 database.
  2. Select Tasks > Detach.
  3. Check the Drop Connections check box and click OK.
  4. In Microsoft SQL Server Management Studio, right-click the DB52 database folder name.
  5. Select Tasks > Restore Database.
  6. In Microsoft SQL Server Management Studio, display the General page.
  7. Change the Destination database name to DB62 and keep the source database name as DB52.
  8. In Microsoft SQL Server Management Studio, display the Options page.
  9. Check the Overwite the existing database (WITH REPLACE) check box and click OK.