SBSmonitoring.mdf too large

Posted on 2006-05-07
Last Modified: 2012-07-03
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?

Question by:tmckinney01
    LVL 74

    Accepted Solution

    You probably don't have the SQLAgent$SBSMONITORING service running and set to start automatically.  That's what keeps the file in check.

    However, you won't be keeping it as small as 100MB... usually it will stay right around 500MB or so.

    If you need more room on your C: drive, however, there are a number of files that can be moved off to a different partition.  See for the how-to.

    LVL 1

    Expert Comment

    If you are using SBS 2008 see


    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction At 19:33 (UST) on Tuesday 21st September the long awaited email arrived with the subject title of “ANNOUNCING THE AVAILABILITY OF WINDOWS SBS 7 PREVIEW”.  It was time to drop whatever I was doing and dedicate as much bandwidth as possi…
    If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now