• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3703
  • Last Modified:

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!
0
telefunken
Asked:
telefunken
  • 4
  • 3
1 Solution
 
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now