Real-time performance monitoring and troubleshooting
Post Reply
perch
Novice
Posts: 3
Liked: never
Joined: Jan 01, 2006 1:01 am
Contact:

Monitor Log file size (.LDF)

Post by perch »

I've noticed our veeam monitor monitor_log.ldf sql log file is getting very large after only a couple months currently at 350GB, anyone have any suggestions as to how to reduce the size, is this normal?
Gostev
Chief Product Officer
Posts: 31805
Liked: 7298 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Post by Gostev »

Hello, this is definitely not normal.
We have discussed this today on the dev meeting, and we believe that this happens due to the SQL server settings/mode you use.

Please, open the support case with our support, and they will assist you in addressing this.
ssimakov
Veeam Software
Posts: 268
Liked: 63 times
Joined: Jan 01, 2006 1:01 am
Full Name: Stanislav Simakov
Contact:

Post by ssimakov »

Andrew,

Please open this database in SQL Management Studio and check "Recovery model" in Options. Make sure that this option is not set to "Full".
prometeus
Lurker
Posts: 1
Liked: never
Joined: Mar 20, 2009 11:08 am
Full Name: Teus
Contact:

Re: Monitor Log file size (.LDF)

Post by prometeus »

ssimakov,

That will effectively disable the ability to restore the DB to a given point in time.
But when an LDF grows it clearly shows that no backup of the logfiles have been made for a long period of time.

its easiest to setup a maintenance plan with the enterprise manager which backups the db + log files. (just point and click)
Gostev
Chief Product Officer
Posts: 31805
Liked: 7298 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Monitor Log file size (.LDF)

Post by Gostev »

Thanks for the suggestion :)
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests