vmware vcenter  transaction log for database 'VIM_VCDB' is full

Cool Guy
Cool Guy used Ask the Experts™
on
The transaction log for database 'VIM_VCDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases


how to solve this issue.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Andrew Hancock (VMware vExpert / EE Fellow)VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017

Commented:
ICT Senior Infraestructure  Engineer  
Commented:
Hi

First you should change your recovery Model database to Simple mode.

Second you should shrink your database.

Articles:

http://kb.vmware.com/kb/1003980

How to shrink database:

http://kb.vmware.com/kb/1036738

For safe keeping, you should trunk your database before reduce/shrink the vCenter DB.

http://kb.vmware.com/kb/1007453

You can also purge the old data from your vCenter DB

http://kb.vmware.com/kb/1025914

Note: Always backup your vCenter DB before any changes.

Hope this can help

Jail

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial