Solved

SBS 2011 Huge SBSMonitoring.mdf

Posted on 2014-02-21
5
8,458 Views
Last Modified: 2016-03-15
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
Comment
Question by:cristallin
5 Comments
 
LVL 29

Assisted Solution

by:Randy Downs
Randy Downs earned 167 total points
ID: 39878457
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
 
LVL 22

Accepted Solution

by:
Olaf De Ceuster earned 167 total points
ID: 39878535
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
 
LVL 5

Assisted Solution

by:Mdlinnett
Mdlinnett earned 166 total points
ID: 39880494
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
 

Author Closing Comment

by:cristallin
ID: 39884523
great fast work
0
 

Expert Comment

by:JackAitken
ID: 41508303
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now