Facebook Twitter Gplus YouTube RSS
Home server SBS 2008 Console May Take Too Long to Display Alerts and Security Statuses, Display Not Available, or Crash, Running Reports
formats

SBS 2008 Console May Take Too Long to Display Alerts and Security Statuses, Display Not Available, or Crash, Running Reports

Published on May 24, 2012 by in server
  1. Download the following file to the server you are going to be working on:
    1. http://cid-d5fe25afb6c3615f.skydrive.live.com/self.aspx/.Public/updateSBSMonitoring.sql
    2. We recommend you save the file to an easy to access path, such as c:\windows\temp.
  2. Complete a backup of the SBSMonitoring Databases
    1. Open Services from Administrative Tools, Services
    2. Accept the UAC prompt
    3. Find and stop the SQL Server (SBSMONITORING) service.
    4. Make a copy of the files in the following folder:
      1. C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
    5. Once the file backup is completed, start the SQL Server (SBSMONITORING) service.
  3. Proceed to run the following set of commands to implement the improvements
    1. Open an Administrative Command Prompt (Run As Admin)
    2. Type the following command, substitute the path to the updateSBSMonitoring.sql file as needed (We recommend that you do NOT copy & paste this command directly from the blog post):
      1. Sqlcmd -S %computername%\SBSMonitoring -E  -i c:\windows\temp\updateSBSMonitoring.sql
      2. Success will show an output like this:
        Changed database context to ‘SBSMonitoring’
        (1 rows affected)

This command can take up to 10 minutes depending upon the speed of the hardware.  Once complete results should improve immediately.

For more information about monitoring your Windows SBS 2008 server, read Monitoring and Reporting in Windows SBS 2008.

 

Sqlcmd -S %computername%\SBSMonitoring -E  -i c:\windows\temp\updateSBSMonitoring.sql

via SBS 2008 Console May Take Too Long to Display Alerts and Security Statuses, Display Not Available, or Crash – The Official SBS Blog – Site Home – TechNet Blogs.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>