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

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 vCloud Automation Center Database with the Source vCloud Automation Center 5.2 Database.

1

Shut down the source 5.2 services. Do not shut down the Model Manager Web Service.

2

Back up the source 5.2 database, for example DB52.

3

Shut down the target 6.1 services. Do not shut down the Model Manager Web Service.

4

Back up the target 6.1 database, for example DB61.

5

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

1

In Microsoft SQL Server Management Studio, right-click the DB61 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 DB61 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.