Link to home
Start Free TrialLog in
Avatar of tmckinney01
tmckinney01Flag for United States of America

asked on

SBSmonitoring.mdf too large

I am running SBS 2003 server, Premium Edition.  I have noticed that the file SBSmonitoring.mdf has grown to over 1GB.  Space on C: is tight, is there any way to shrink this file and keep it from growing past a certain size, such as 100MB?

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Kane - TechSoEasy
Jeffrey Kane - TechSoEasy
Flag of United States of America 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
Avatar of darnitol500
darnitol500

If you are using SBS 2008 see http://support.microsoft.com/kb/2000544

Summary:

This will occur if the database is configured to use the default setting of full recovery mode and numerous transactions have been logged to the database.  Either run the Fixit or copy, paste, and run the sql commands included on the page.