• Home
  • Consulting
  • Contact Us
    • About this site
    • Contact Wayne
    • Media Room
    • Wayne’s Bio

SBSFAQ.COM

Supporting IT Pro's & MSP's since 2000

  • Blog
  • FAQs
  • Reviews
  • Downloads

SBS 2008 Monitoring Database grows too big

November 7, 2011 by Wayne Small 13 Comments

Yes – I had this happen on my SBS 2008 server myself.  Instead of taking the normal route to try and resolve it however, I decided to mess with a few SQL commands and try to dig under the covers to see if I could delete data that was too old.  I thought that this might allow me to reduce the content of the database so that I could not go through the hassle of replacing it.  Sadly my SQL skills are not that good and I ended up making the database log files all that much more bigger to the point that I nearly ran out of disk space.

image

Oh well – I tried it on my system and not a customers system.

End result however is that if your SBS 2008 Monitoring Database grows beyond the 4GB limit, you’ve got no real choice but to replace it with an empty one.  Best place to get one is from a new customer server – or if you don’t have one of those, then you can download a fresh one from here .

Once you have your empty database, the procedure is quite simple.

  1. Stop any backups that you have running – ie the SBS 2008 backup or ShadowProtect.
  2. Open the Services MMC from the Administrative Tools program group
  3. Stop the Windows SBS Manager service and the SQL Server (SBSMONITORING) service.
  4. Rename or in my case delete the SBSMonitoring.mdf and the SBSMonitoring_log.ldf files from the C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder
  5. Copy the replacement LDF and MDF files into the same location
  6. Start the SQL Server (SBSMONITORING) service
  7. Start the Windows SBS Manager service
  8. Given that you’ve replaced the database with an empty one, you will need to use the SBS 2008 Console and reconfigure your reporting and alerts.
  9. Also do not forget to re-enable your backups once more and do a backup of your server with the new database in place.

To configure SBS 2008 Alert Notifications do the following;

  1. Open the Windows SBS Console
  2. Select the Network tab
  3. Select the View notification settings task from the task pane on the right hand side
  4. Select the Email Address tab and enter in your email address for notifications
  5. Select OK to close and save the settings

To configure SBS 2008 Reports do the following;

  1. Open the Windows SBS Console
  2. Select the Reports tab
  3. Select the Add a new report task from the task pane on the right hand side
  4. Configure the report to contain the information you need and select OK

Share this:

  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to print (Opens in new window)

Filed Under: Blog Tagged With: Performance, Reports, SBS 2008

About The Author

Wayne has been working with Microsoft Server products in the SMB market for over 20 years. He has a passion for technology and been a Microsoft MVP for over 15 years. Read More…

Comments

  1. Callum says

    March 10, 2014 at 3:59 am

    I all the time used to study post in news papers but now as I am a user of internet therefore from now I am
    using net for articles, thanks to web.

    Reply
  2. free cash formula says

    May 1, 2014 at 1:52 am

    You actually make it appear really easy together with your presentation but I in finding this
    matter to be really one thing which I think I would
    by no means understand. It seems too complex and extremely
    large for me. I am taking a look forward
    to your next put up, I will attempt to get the grasp of it!

    Reply
  3. profitable niche online says

    July 9, 2014 at 1:37 pm

    Excellent post. I used to be checking constantly this blog and I’m inspired!
    Very useful information specially the final section :
    ) I deal with such information much. I was looking for this certain info for a long time.
    Thank you and good luck.

    Reply
  4. inboxblueprintreviewed.net says

    July 31, 2014 at 2:40 pm

    You are so awesome! I don’t suppose I have read through anything like this
    before. So great to find someone with a few unique thoughts on this issue.
    Really.. many thanks for starting this up. This web site is something that’s needed
    on the web, someone with some originality!

    Reply
  5. skrotpræmie says

    August 25, 2014 at 8:49 pm

    Can you tell us more about this? I’d love to find out
    more details.

    Reply
  6. twitter.com says

    September 18, 2014 at 3:59 am

    Wonderful post however , I was wanting to know if you could
    write a litte more on this subject? I’d be very thankful if you could elaborate a little bit more.

    Bless you!

    Reply
  7. clip adulte gratuit says

    September 25, 2014 at 10:49 am

    Un сonsidérable remerϲiement au ϲréateur de ce site web

    Herе is myy homepage … clip adulte gratuit

    Reply
  8. damien-piller.fr says

    September 29, 2014 at 5:41 pm

    Superb post but I was wondering if you could write a litte more on this subject?

    I’d be very grateful if you could elaborate a little bit more.
    Kudos!

    Reply
  9. serviced apartments in singapore little india says

    September 30, 2014 at 11:02 pm

    One thing that goes in complete favor of corporate apartments is that there are no hidden charges.

    Quay Apartment is an excellent leader to providing holiday
    service apartments Manchester and cheap hotels manchester city
    centre in United Kingdom. With so many more attractions to be explored,
    Edinburgh has the magic of making your holiday or business trip very interesting and exciting.
    You can cook for yourself in your serviced apartment and enjoy the food of
    your choice.

    Reply
  10. 3mala.net says

    October 4, 2014 at 7:51 am

    It all depends upon what you wear and what you take along with you.
    Your vehicle can be backed right up to the water and can be left while you
    explore the area waterways. Some people devote their lives to activities such as kayaking.
    And who would miss the funny acrobatic dolphin show in the blue horizons and fascinating acrobatic presentations Odyssea show with an underwater theme.

    Reply
  11. lumens says

    October 5, 2014 at 4:26 am

    Wow that was unusual. I just wrote an incredibly long comment but after I clicked submit my comment
    didn’t appear. Grrrr… well I’m not writing all that over
    again. Anyhow, just wanted to say great blog!

    Reply
  12. Nichol says

    November 29, 2014 at 2:56 pm

    Keep up the amazing job !! Lovin’ it! If you loved this short article and you would such as to get even more details relating to horizon treadmill reviews price range kindly browse through our webpage.| http://findyourtreadmill.com

    Reply
  13. Walter says

    May 9, 2019 at 6:02 am

    The link for the db is now broken

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Search

Connect Online With Us

  • Facebook
  • Twitter

Reviews

Splashtop – Cost Effective Remote Control Software

September 22, 2017 By Wayne Small 2 Comments

Western Digital DL4100 NAS

March 3, 2015 By Wayne Small Leave a Comment

SBS 2011 Configuring Certification Guide (70-169)

August 7, 2012 By Wayne Small 4 Comments

Site News

Exchange Bug Stops Mail Delivery in 2022

January 2, 2022

Huge bug found in Intel CPU that could permit hackers to steal your data

January 4, 2018

Recent Posts

  • World Backup Day – What does it mean to Australians?
  • New Teams update finally allows easy cross organisation switching
  • MS Exchange Zero Day and RemotePowerShell Disabling on Admin accounts
  • Setup changes for Exchange 2016 and Exchange 2019
  • Bluetooth Mouse and Keyboard Randomly Stop Responding

Tags

Antivirus Backup Business Focus Cloud Computing Community Conferences Disaster Recovery Exchange 2010 Exchange Server Future Products Hyper-V Installation Microsoft Migration Patches Personal Rants SBS 4.5 SBS 2000 SBS 2000 SP1 SBS 2003 SBS 2003 Premium SBS 2003 R2 SBS 2003 R2 Premium SBS 2003 R2 Standard SBS 2003 SP1 Premium SBS 2003 SP1 Standard SBS 2003 Standard SBS 2008 SBS 2008 R2 SBS 2011 SBS 2011 Essentials SBS 2011 Standard Security Service Packs ShadowProtect Software Software I use StorageCraft Training TrendMicro Troubleshooting Virtualisation Windows Server 2012 Essentials Windows Storage Server 2008 R2 Essentials

Terms of Use

Privacy Policy

Copyright © 2023 · Magazine Pro Theme on Genesis Framework · WordPress · Log in