SBS 2011 Huge SBSMonitoring.mdf

Ml350G6 32GB RAM  running SBS 2011. Installation not maintained.....
 SBSMonitoring.mdf is at 10,383.3 MB
 SBSMonitoring_log.LDF  at 672.3MB

any suggesting on reducing or shrinking this seems way to large.


best
Richard
careplus.png
cristallinAsked:
Who is Participating?
 
Olaf De CeusterConnect With a Mentor Commented:
Hope this helps,
https://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx
Bat file attached to make room deleting unwanted log files. Run as admin on server
Olaf
SBS2008DiskCln.cmd
0
 
Randy DownsConnect With a Mentor OWNERCommented:
Try this

For SBS 2011 Standard

Launch "C:\Program Files\Windows Small Business Server\Bin\MoveDataPowerShellHost.exe" as an administrator
Launch the script:
C:\windows\temp\Create-SBSMonitoringDb.ps1
0
 
MdlinnettConnect With a Mentor Commented:
Hi Richard,

I recreated the SBS Monitoring database myself on Friday following the steps of the article provided.  

After unzipping the .ps1 file I did have to unblock the file as the article suggests.

The MoveDataPowershellHost.exe launches a command window, from within that window, execute the script.

You may well get a lot of alerts following the recreation of the database.  Don't forget to go into the Console and resupply the email addresses for the Summary / Detailed Network reports and your Notification Settings.
0
 
cristallinAuthor Commented:
great fast work
0
 
JackAitkenCommented:
Does this script remove the old MDF & LDF before creating new or do we need to stop the services and delete the old SQL database
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.

All Courses

From novice to tech pro — start learning today.