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!
telefunkenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ady FootSharePoint ConsultantCommented:
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
0
telefunkenAuthor Commented:
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  
0
Ady FootSharePoint ConsultantCommented:
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
0
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

telefunkenAuthor Commented:
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
0
telefunkenAuthor Commented:
this solved my problem:

-------------------------------------
On the ToDo list in SBS Management you can click on the Monitoring link and choose "Reinstall".  It starts the database at zero.  I use the Monitoring for alerts mostly and not for historical tracking.

posted by SmilinJack, in:  03/27/08 08:13 AM, ID: 21220434

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_23273620.html?sfQueryTermInfo=1+sbsmonitor
---------------------------------

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ady FootSharePoint ConsultantCommented:
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
0
telefunkenAuthor Commented:
Ady,  Thank you!  I do with I could "throw some points at ya!"  though.  Thanks for your thoughtful comment friend.  Best,  ----tele
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.