Is it possible to keep the old database for historical data (I realize the schema will be upgraded) but stop services on the old VirtualCenter server, create a DSN on a new named VM, install vSphere and access the old db?
I'd like to retain my historical data in the database but have a fresh built vC (vSphere4.1) which will have a different hostname.
There's a bug in the update scripts though: They don't seem to account for path changes in ms SQL db location, so I had to use sqlcmd to restore the db, which allows for sth like restore database path = 'path to upgraded db backup' move VIM_VCDB_data 'new path to data .ldf', move VIM_VCDB_log 'new path to log .ldf' go
It's off the top of my head, so syntax might not be entirely correct.
You can use the SQL Server Management studio and follow the steps given below.It should be a simple procedure as per the guide.Hope thhis will help.
1 On the source machine, stop the VirtualCenter service.
a Select Start > Programs > Administrative Tools > Services.
b Right-click VMware VirtualCenter Server and select Stop.
2 In SQL Server Management Studio, make a full back up of the source machine database.
3 Copy the backup file (.bak) to the C:\ drive on the destination machine.
4 On the destination machine, open SQL Server Management Studio and right-click the Databases folder.
5 Select New Database, enter the source machine database name, and click OK.
6 Right-click the new database icon and select Task > Restore > Database.
7 Select From Device and click Browse.
8 Click Add, navigate to the backup file, and click OK.
9 In the Restore Database window, select the check box next to your .bak file.
10 On the Options page, select the Overwrite the existing database check box and click OK.