VMware vSphere 4 Installation Guide download pdf (Page 51)

4 When the detach operation is complete, copy the data files (.mdf and .ldf) to the destination machine's

database folder.

By default, the database folder is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.

5 In SQL Server Management Studio on the destination machine, right-click the Databases directory and

select Attach.

6 Select the .mdf file that you copied to the destination machine's database folder and click OK.

The database from the source machine is attached to the destination machine.

What to do next

See http://kb.vmware.com/kb/1004382. As indicated in Knowledge Base article 1004382, detaching and

attaching the vCenter Server database to a different Microsoft SQL Server does not copy over the vCenter

Server specific SQL Agent daily, weekly, and monthly rollup jobs. Therefore, in KB 1004382, see "verifying

the existence of jobs and removing them."

See “Upgrade to vCenter Server on a Different Machine,” on page 52. This information applies when

you migrate vCenter Server to a different machine. For example, because the hardware is being

decommissioned or the operating system is no longer supported because of an upgrade.

Back Up and Restore an Oracle Database

Before you perform an upgrade to vCenter Server on a different machine, you might want to move the database

as well. Moving the database is optional. To move an Oracle database, you perform a backup and restore

operation.

Consult your database administrator or see your database documentation about backing up and restoring

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

You must have a VirtualCenter 2.x system running with a local or remote Oracle 10g or Oracle 11g database.

Procedure

1 On the source machine, log in to Oracle SQL*Plus as the VirtualCenter 2.x database user and export the

database as a .dmp file.

2 Copy the .dmp file onto the C:\ drive of the destination machine.

3 In Oracle SQL*Plus, run the following command to create the tablespace.

create tablespace vctest datafile 'c:\vctest.dbf' size 100m autoextend on;

4 Create a user.

create user VCUSER identified by CENSORED default tablespace vctest;

5 Import the .dmp file into the Oracle 64-bit database on the destination machine.

The VirtualCenter 2.x database is 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.

Chapter 7 Upgrading to vCenter Server on a Different Machine and Keeping the Existing Database

VMware, Inc. 51

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

No comments

VMware vSphere 4 Installation Guide Page 51