Notes:
- Before reinitializing the database, attempt a restore from a previous database backup.
- vCenter Server database user should have db_owner role on the database in order to re-initialize.
To initialize a SQL database:
Warning: Reinitializing your vCenter Server database deletes all information about your virtual environment that is managed by vCenter Server. Before proceeding, VMware recommends you to have a valid backup of your database. For more information, see Backing up the vCenter Server database running on Microsoft SQL or SQL Express server (2012138)
- Stop the VMware VirtualCenter Server service.
To stop the VMware VirtualCenter Server service:
- Log in to the server that is running vCenter Server as an administrator.
- Click Start > Run, type services.msc, and click OK.
- From the list of services, right-click VMware VirtualCenter Server service and click Stop.
- Click Start > All Programs > Accessories, right-click Command Prompt and click Run as Administrator. The Command Prompt window opens.
- Navigate to the installation directory of vCenter Server. By default, the installation directory is located at C:\Program Files\VMware\Infrastructure\VirtualCenter Server.
- Run this command to initialize the database :
vpxd -b
- Wait for the command to complete and then start the VMware VirtualCenter Server service.