Solutions Through IT

May 8, 2012

SBS Monitoring Failure

Filed under: DRP (Disaster Recovery Planning), Microsoft, SBS, SBS 2008, SBS 2011 — solutionsthroughit @ 14:48

So I’ve jumped onto a server, and the monitoring had stopped functioning.  Corrupt database no less.  Having read up about this before, I whipped out a few trusty URLS.  They were in two places, plus I’ve added a twist at the end (which I believe is configured as part of the re-create step, but I’ve included it as it can cause problems).

Step one was here, to recreate the SBS Monitoring database and downloaded the Create-SBSMonitoringDB.zip file.  Extracted this, and fired up a powershell console, making sure I right-clicked and selected Run as Administrator.

If your system is default/secure, you’ll need to change your policy.  Ensure that you check the policy before you relax security, so that you can return it to the same setting.

image

Navigate to the directory you extracted the zip file, and execute the script.  This will recreate the database for you.

Once this is completed, I navigated over to here, to get a copy of the SQL to reduce the cleanup period, and create some indexes for performance.  I’ve taken the liberty of adding the last step, to ensure that the databse is in SIMPLE mode, reducing the SQL log file to the smallest size, on a system that is backed up correctly.

USE SBSMonitoring

UPDATE [SBSMonitoring].[dbo].[Settings] SET [Value] = 30 WHERE [Name] = 'CleanupPeriod'

EXECUTE [SBSMonitoring].[dbo].[CleanupDatabase]

CREATE NONCLUSTERED INDEX [_SBS_BLOG_index_WMICollectedData_5_K4_K1_K5_2] ON [dbo].[WMICollectedData] ([WMIPropertyID] ASC,[ID] ASC, [WMIInstanceID] ASC) INCLUDE ( [DateCollected]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [_SBS_BLOG_index_Reports_5_K2_K3_1_4] ON [dbo].[Reports] ([ConfigurationID] ASC, [DateGenerated] ASC) INCLUDE ([ID], [Data]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [_SBS_BLOG_index_WMICollectedData_5_K2D_K4_K5] ON [dbo].[WMICollectedData] ([DateCollected] DESC, [WMIPropertyID] ASC, [WMIInstanceID] ASC) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE INDEX [_SBS_BLOG_index_Alerts_8_7_] ON [SBSMonitoring].[dbo].[Alerts] ([DefinitionID], [ComputerID]) INCLUDE ([DateOccured])

CREATE STATISTICS [_SBS_BLOG_stat_WMICollectedData_5_1_4] ON [dbo].[WMICollectedData]([WMIInstanceID], [ID], [WMIPropertyID])

CREATE STATISTICS [_SBS_BLOG_dta_stat_WMICollectedData_4_1_5_2_3] ON [dbo].[WMICollectedData]([WMIPropertyID], [ID], [WMIInstanceID], [DateCollected], [StatusID])

CREATE STATISTICS [_SBS_BLOG_dta_stat_WMICollectedData_5_1_3_4] ON [dbo].[WMICollectedData]([WMIInstanceID], [ID], [StatusID], [WMIPropertyID])

CREATE STATISTICS [_SBS_BLOG_dta_stat_WMICollectedData_5_4_2] ON [dbo].[WMICollectedData]([WMIInstanceID], [WMIPropertyID], [DateCollected])

CREATE STATISTICS [_SBS_BLOG_stat_WMICollectedData_2_1_5] ON [dbo].[WMICollectedData]([DateCollected], [ID], [WMIInstanceID])

CREATE STATISTICS [_SBS_BLOG_stat_WMICollectedData_1_3_5_2] ON [dbo].[WMICollectedData]([ID], [StatusID], [WMIInstanceID], [DateCollected])

ALTER DATABASE SBSMonitoring SET RECOVERY SIMPLE

Advertisements

Create a free website or blog at WordPress.com.