VMwareKB
This issue occurs when transaction log (.ldf ) size of the vCenter Server database exceeds the maximum limit.
To resolve this issue, change the recovery model to simple and shrink the transactional logs. For steps to troubleshoot transaction log issues in the Microsoft SQL database server, see Troubleshooting transaction logs on a Microsoft SQL database server (1003980).
This issue may also occur if the password for the account on the SQL database server used to connect to the vCenter Server database has expired.
To resolve this issue, ensure that the account password is valid. For more information, see VirtualCenter Server service fails to start with the error: The password for user account ' ' has expired (1012498).
For a vCenter Server installation with a database on an embedded SQL Server Express, the issue might occur if the transaction log size is reached.
To resolve this issue, verify the name of the SQL Server instance and change the transaction log size.
To verify the name of the SQL Server instance and change the transaction log size:
1.Verify the actual name of the SQL Server instance used with vCenter Server.
1.Start the ODBC Data Sources manager from the Control Panel > Administrative Tools > Data Sources (ODBC).
2.Select VMware VirtualCenter DSN in the System DSN tab and click configure to see the details.
3.The server name is shown in the Server edit box.
2.Use the SQL Server command line tool to change the transaction log size limit.
1.Start the command prompt.
2.Run the command osql -S
-E
3.Run next SQL:
a.go
b.ALTER DATABASE [VIM_VCDB]
c.MODIFY FILE ( NAME = N'VIM_VCDB_LOG', MAXSIZE = UNLIMITED )
d.go
4.Exit the command tool by typing exit.