database logs

[khaliqamar]

hello,

i am having a sudden growth of transaction logs of my vmware database.

when i check vpx.event table it is only around 4 gb but i dont know how much growth of it for today ?

On backup side , everything looks fine.

is there any way i can find out which thing caused it ?

I am running 4.1

thanks in advance !!

[rcporto]

I had a similar problem with Rollup Jobs not working as expected and growing the transaction logs... another thing to check is the recovery model for database, this should be Simple.

[Borja_Mari]

Hello,

your vcenter database transaction log isn't becoming full, anyway i would recommend you to check carefully this:

Troubleshooting when the vcenter db transaction log becomes full (MS SQL server 2005 express)

Maybe it can be helpful.

Best regards,

Pablo

[khaliqamar]

guys it comes out that the backup did not run that day.

Thanks for the comments

[Borja_Mari]

Ok, hehehe

If the database backup (i guess your sql server database is running in the full recovery mode) isn't done, then the transaction log isn't truncated/shrinked.

Best regards,

Pablo

[khaliqamar]

Hi Pablo,

yes, you are correct actually it is running a  FULL recovery mode.

Actually backup engineer disable job scheduler  for maintenance so that day job did not run which makes a sudden transaction logs bigger then it usually transfer and there was no logs for even failed jobs because the transaction log job did not run.

Thanks Pablo !!