Monitor Log file size (.LDF)

Real-time performance monitoring and troubleshooting

Monitor Log file size (.LDF)

Veeam Logoby perch » Mon 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?
perch
Novice
 
Posts: 3
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Veeam Logoby Gostev » Tue 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.
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Veeam Logoby ssimakov » Tue 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".
ssimakov
Veeam Software
 
Posts: 300
Liked: 23 times
Joined: Sun Jan 01, 2006 1:01 am
Full Name: Stanislav Simakov

Re: Monitor Log file size (.LDF)

Veeam Logoby prometeus » Fri 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)
prometeus
Lurker
 
Posts: 1
Liked: never
Joined: Fri Mar 20, 2009 11:08 am
Full Name: Teus

Re: Monitor Log file size (.LDF)

Veeam Logoby Gostev » Fri Mar 20, 2009 11:38 am

Thanks for the suggestion :)
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 6 guests