SBS 2008 sbsmonitoring database log file size

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.
snowdog_2112Asked:
Who is Participating?
 
Cris HannaConnect With a Mentor Commented:
http://www.thirdtier.net/2010/03/sbs-2008-monitoring-database-fills-to-capacity/
This blog post will have you download a file and run it which will cause the database to dump data older than 90 days...out of the box, the database never dumps data.
0
 
Cris HannaCommented:
0
 
snowdog_2112Author 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?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
snowdog_2112Author 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)?
0
 
Cris HannaCommented:
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.
0
 
snowdog_2112Author Commented:
Forced to accept something.  MS Sucks.
0
All Courses

From novice to tech pro — start learning today.