How to relocate the SQL database that is used by VirtualCenter.
To move SQL Server databases which are used by VirtualCenter, to a new location.
1.Stop the VMware VirtualCenter Server and VMware Update Manager Service.
2.Migrate the databases according to Microsoft's How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server.
3.Verify the Datasource (DSN) in the ODBC Administrator to reflect any changes made.
4.Update the login credentials that VirtualCenter uses to connect to the database.
See Modifying the username and password VirtualCenter uses to connect to the database server in "Troubleshooting the database data source used by VirtualCenter Server (1003928)".
5.Recreate SQL Agent rollup jobs. Detaching, attaching, importing and restoring a database to a newer version of SQL Server does not automatically recreate these jobs.
6.Start the VMware VirtualCenter Server and VMware Update Manager Service.