- Download the following file to the server you are going to be working on:
- We recommend you save the file to an easy to access path, such as c:\windows\temp.
- Complete a backup of the SBSMonitoring Databases
- Open Services from Administrative Tools, Services
- Accept the UAC prompt
- Find and stop the SQL Server (SBSMONITORING) service.
- Make a copy of the files in the following folder:
- C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
- Once the file backup is completed, start the SQL Server (SBSMONITORING) service.
- Proceed to run the following set of commands to implement the improvements
- Open an Administrative Command Prompt (Run As Admin)
- 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):
- Sqlcmd -S %computername%\SBSMonitoring -E -i c:\windows\temp\updateSBSMonitoring.sql
- 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