VMware vSphere 4 Installation Guide download pdf (Page 50)

You must have Microsoft SQL Server Management Studio installed on the source machine and the

destination machine. The Express versions (SQLServer2005_SSMSEE.msi and

SQLServer2005_SSMSEE_x64.msi) are free downloads from Microsoft.

Procedure

1 In SQL Server Management Studio, make a full back up of the source machine database.

2 Copy the backup file (.bak) to the C:\ drive on the destination machine.

3 On the destination machine, open SQL Server Management Studio and right-click the Databases folder.

4 Select New Database, enter the source machine database name, and click OK.

5 Right-click the new database icon and select Task > Restore > Database.

6 Select From Device and click Browse.

7 Click Add, navigate to the backup file, and click OK.

8 In the Restore Database window, select the checkbox next to your .bak file.

9 On the Options page, select the Overwrite the existing database checkbox and click OK.

The VirtualCenter 2.x database is successfully restored onto the new database, which you can use for the

upgrade to vCenter Server 4.0.

What to do next

See “Upgrade to vCenter Server on a Different Machine,” on page 52.

Detach and Attach a Microsoft SQL Server Database

Before you perform an upgrade to vCenter Server on a 64-bit machine, you can optionally detach the

VirtualCenter 2.x database from the source machine and attach it to the destination machine. This is an

alternative to the backup and restore operation.

Consult your database administrator or see your database documentation about detaching and attaching

databases.

The machine with the VirtualCenter 2.x database is referred to as the source machine. The machine on which

the vCenter Server 4.0 database will reside is referred to as the destination machine.

Prerequisites

Take a full backup of the database.

You must have a VirtualCenter 2.x system running with a local or remote Microsoft SQL Server database.

You must have Microsoft SQL Server Management Studio installed on the source machine and the

destination machine. The Express versions (SQLServer2005_SSMSEE.msi and

SQLServer2005_SSMSEE_x64.msi) are free downloads from Microsoft.

Procedure

1 On the source machine, stop the VirtualCenter service.

a Selecting Start > Control Panel > Administrative Tools > Services > VMware VirtualCenter Server.

b Right-click VMware VirtualCenter Server and select Stop.

2 In the SQL Server Management Studio, open the Databases directory, right-click the VirtualCenter 2.x

database, and select Tasks > Detach.

3 Select the database and click OK.

vSphere Upgrade Guide

50 VMware, Inc.

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 109 110

No comments

VMware vSphere 4 Installation Guide Page 50