Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 14255
  • Last Modified:

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
0
cristallin
Asked:
cristallin
3 Solutions
 
Randy DownsOWNERCommented:
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
 
Olaf De CeusterCommented:
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
 
MdlinnettCommented:
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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