Solved

SBS 2008 sbsmonitoring database log file size

Posted on 2010-11-15
8
2,973 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.
0
Comment
Question by:snowdog_2112
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 34142810
0
 

Author Comment

by:snowdog_2112
ID: 34151039
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
 
LVL 35

Accepted Solution

by:
Cris Hanna earned 500 total points
ID: 34227705
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:snowdog_2112
ID: 34364483
"...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
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 34364515
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
 

Author Closing Comment

by:snowdog_2112
ID: 34461647
Forced to accept something.  MS Sucks.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question