tmckinney01
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.