We help IT Professionals succeed at work.

SBS 2008 sbsmonitoring database log file size

3,086 Views
Last Modified: 2012-05-10
How do I prevent the sbsmonitoring LDF file from growing to ridiculous size?

In the SQLEE Studio, the log file is set to 2GB, yet mine was close to 4GB just now.  I had to run a manual backup and then Shrink.

What gives?  Does SBS maintain the db (i.e., backup and shrink) on its own, or is it one more thing I need to constantly worry about?

Thanks.
Comment
Watch Question

Cris HannaSr IT Support Engineer
CERTIFIED EXPERT

Commented:
http://support.microsoft.com/kb/2000544

Author

Commented:
That tell me how to shrink it, but not how to *prevent* it from growing going forward.  As mentioned, I have it set to limit the size, but it clearly grew beyond that.

Or do I really have to monitor the database that is supposed to be monitoring my SBS server?
Sr IT Support Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
"...out of the box, the database never dumps data"

Understood, but can it be coerced into dumping data, similar to the event logs (e.g., keep 7 days, or don't exceed 1024k)?
Cris HannaSr IT Support Engineer
CERTIFIED EXPERT

Commented:
In the link to the  blog, you will find a script to download which you will run on the SBS server and it will cause the database to dump data older than 90 days.

Author

Commented:
Forced to accept something.  MS Sucks.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.