Link to home
Start Free TrialLog in
Avatar of Michael Green
Michael GreenFlag for Australia

asked on

purge or delete or re-initilaise sbsmonitoring database (sbsmonitoring.mdf, sbsmonitoring.ldf)

Hi,
I currently have the SBSMonitoring database using a huge amount of space on Small Business Server 2008 (sbs2008)

sbsmonitoring.mdf    994.2MB
sbsmonitoring.mdf    611.1MB

Is there an easy way to purge, delete or re-initialise this database to get the size down ?

Regards
Michael
Avatar of Larry Struckmeyer MVP
Larry Struckmeyer MVP
Flag of United States of America image

Hi:

In the SBS console, under Monitoring, run the setup wizard.  This will clear the history so you will not have comparisons in the reports, but it will lower the space consumed.

How big is your system partion?  1.5 GB is not "huge" for this database.
Avatar of Michael Green

ASKER

Where is 'Monitoring' located on the SBS2008 console ?
Sorry, keep getting the versions mixed....

You still are nowhere near any limits on these files.  If your system partition is lacking free space, either the partition is too small or there are other things using the space.

Here are two articles that explain it.  Note, Please read them both to the end.

http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx

and

http://www.thirdtier.net/2010/03/sbs-2008-monitoring-database-fills-to-capacity/
The customer's C: drive is quite small - hence the issue.

I read all three articles - have seen this about updateSBSMonitoring.sql  before.

I ran updateSBSMonitoring.sql per the procedure.

It did NOT decrease the database size - it INCREASED IT !.  And the log file size TOO ! (to over a gig).

Is this the result you expected ?
Not what I expected and not sure what that is about, but you will be fighting this forever.  Probably better to increase the size of the system partition.

Also, "run as administrator" either wirdirstat or treesizepro to see what else is consuming space on that system.
ASKER CERTIFIED SOLUTION
Avatar of Michael Green
Michael Green
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And yes - Windirstat is very useful.  But that is how I identified this size issue in the first place...:)
Solution required combining multiple steps/suggestions