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 » Sep 29, 2008 5:59 pm

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
Veeam Software
Posts: 23111
Liked: 2915 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Post by Gostev » Sep 30, 2008 2:59 pm

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: 317
Liked: 34 times
Joined: Jan 01, 2006 1:01 am
Full Name: Stanislav Simakov
Contact:

Post by ssimakov » Sep 30, 2008 3:59 pm

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 » Mar 20, 2009 11:14 am

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
Veeam Software
Posts: 23111
Liked: 2915 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Monitor Log file size (.LDF)

Post by Gostev » Mar 20, 2009 11:38 am

Thanks for the suggestion :)

Post Reply

Who is online

Users browsing this forum: jruddy09 and 7 guests