The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Migrating the vCenter Server database from SQL Express 2005 to SQL Server 2008 (1028601)
Note: You may need to migrate from SQL Express to SQL Server if you're close to, or exceeding one or all of the following maximums: 5 hosts, 50 virtual machines, or 4GB database size.
To migrate the vCenter Server database from SQL Express 2005 to SQL Server 2008:
Note: Ensure that you are using the dbo schema and not custom schemas in your vCenter database. For more information, see Upgrading vCenter Server to a newer version fails with multiple schema errors (1011386).
Stop the VirtualCenter Server service. For more information, see Stopping, starting, or restarting VirtualCenter services (1003895).
Take a complete backup of the vCenter database. Do not skip this step.
Stop the vCenter database on SQL Express 2005.
Copy the backed up database to the SQL Server 2008 host.
Create a new database on SQL Server 2008.
Restore the backed up SQL Express 2005 vCenter database to the newly created database. To ensure a proper restore, go to Options and click Overwrite existing database with replace.
The instructions above also apply when SQL Server 2008 is installed locally on the vCenter server. SQL Express 2005 is upgrade to SQL Server 2008 after you have created the new 2008 database and restored the SQL Express 2005 database to the SQL 2008 Server.
You must remove and recreate the System DSN so that it uses the SQL Native Client 10.0 driver, which you can download from here.
The preceding link was correct as of December 07, 2012. If you find the link is broken, provide feedback and a VMware employee will update the link.
Ensure the DSN connects to the newly created database on SQL 2008 Server. For vCenter Server 4.1 and later, ensure a 64-bit DSN is created for the ODBC connection.
Configure the vCenter account that connects to the database as the dbo user of the MSDB system database. For more information on database requirements, see:
- Preparing the vCenter Server Databases section of the ESX and vCenter Server Installation Guide
- For more information, see Administrative credentials are required for Oracle and SQL Server databases when installing or upgrading vCenter Server (1003052)
- Uninstall vCenter Server.
- Reboot the vCenter Server host.
- Install vCenter Server.
- In the installation wizard, select the newly created DSN that connects to your SQL 2008 database and select the Do not overwrite, leave my existing database in place option.
- Ensure that the authentication type used in SQL 2008 is the same as that used on SQL Express 2005.
- Reset the permissions of the vCenter account that connects to the database as the dbo user of the MSDB system database.
Note: This procedure also applies when SQL Express is upgraded to SQL Server 2005.
- Administrative credentials are required for Oracle and SQL Server databases when installing or upgrading vCenter Server
- Upgrading vCenter Server to a newer version fails with multiple schema errors
- Cannot start the VirtualCenter Server service after migrating the vCenter Server database to a new server
- Verifying jobs and stored procedures in VMware vCenter Server 4.1.x
- Verifying jobs and stored procedures installed in VMware vCenter Server 5.0
- SQL Express 2005 から SQL Server 2008へのvCenter Server データベースの移行
- Verifying jobs and stored procedures installed in vCenter Server 5.1
- Moving the vCenter Server SQL database
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.