asked on 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.
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.
VMwareSBSNetworkingDatabases
Last Comment
snowdog_2112
http://support.microsoft.com/kb/2000544
ASKER
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?
Or do I really have to monitor the database that is supposed to be monitoring my SBS server?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
"...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)?
Understood, but can it be coerced into dumping data, similar to the event logs (e.g., keep 7 days, or don't exceed 1024k)?
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.
ASKER
Forced to accept something. MS Sucks.