asked on

SBSmonitoring.mdf I really want to delete this to purge urgent C: drive memory crunch. Bad idea?

in this folder:

C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING\Data

is a file called: SBSMonitoring.mdf

I'd like to delete this file temporarily (I have also disabled the MSSQL$SBSmonitoring service)

This is quite urgent...as my C: drive is less that 900MB free space

Alternatively, could I delete safely the old Service Pack files ($NTUninstallxxxxxxx) to create quick breathing room?

Thanks!

Ady Foot

Don't delete the SBSMonitoring.mdf file - this is a database that runs your SBSMonitoring instance. Very much needed for your SBS installation.
You can absolutely delete the old service pack files though which should help provide the much needed extra space. Obviously this means you cannot uninstall the service packs/updates at a later date but this shouldn't pose too much risk at all.
Regards,
Ady

telefunken

ASKER

But it's many GB in size and I want to start over with monitoring. There has to be a way to keep this dabase filesize constrained....right? Thanks

Ady Foot

It seems as though the SQLAgent$SBSMONITORING service is what is responsible for keeping that MDF file in check. It should hover around the 500MB mark. Please check to ensure that this service is running and is set to run automatically.

I take it your main data is off the C drive and stored on another partition? If not, please see the following article for help moving it off:
http://msmvps.com/blogs/bradley/archive/2004/04/26/5531.aspx

Regards,

Ady

telefunken

ASKER

Thanks Ady,

A few hours ago I re-started both the SQLmonitoring service AND the SQLAgent..........

But, still, the SBSMonitoring.mdf file is 2.1GB !!

Do I have to wait for it to reduce? Is there anyway for me to "reset" it manually?

Thanks, tele

ASKER CERTIFIED SOLUTION

telefunken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ady Foot

Hi telefunken,

I'm very pleased you managed to resolve the issue. You are absolutely right to have this question closed by accepting your answer as the solution. Unfortunately no way to give me 250 points but I don't think they would be deserved in any case, I was slightly off the mark on this particular occasion.

It was VERY refreshing, however, that you considered my input. Sometimes question authors forget that we do this for free and don't always seem appreciative.

All the best,

Ady

telefunken

ASKER

Ady, Thank you! I do with I could "throw some points at ya!" though. Thanks for your thoughtful comment friend. Best, ----tele