SBS 2011 sbsmonitoring adatbázis pucolás

Ha túl nagyra nő az SBSMonitoring.mdf adatbázis, lelassul a szerver, a DataCollectorSvc.exe rengeteg memóriát eszik.

Az adatbázis újrakreálása:

To recreate the databases use these steps:

    1. Download the following package:

https://skydrive.live.com/self.aspx/.Public/MonitoringDBRecreate/Create-SBSMonitoringDb.zip?cid=d5fe25afb6c3615f&sc=documents

  1. Extract the files to c:\windows\temp
  2. Complete the one set of the following steps according to the version you are working with:

For SBS 2008

  1. Launch an administrative PowerShell session
  2. Launch the script:
    C:\windows\temp\Create-SBSMonitoringDb.ps1
  3. After completing the script and verifying that that monitoring is working, complete the steps in this article:http://blogs.technet.com/b/sbs/archive/2009/07/14/sbs-2008-console-may-take-too-long-to-display-alerts-and-security-statuses-display-not-available-or-crash.aspx

For SBS 2011 Standard

  1. Launch “C:\Program Files\Windows Small Business Server\Bin\MoveDataPowerShellHost.exe” as an administrator
  2. Launch the script:
    C:\windows\temp\Create-SBSMonitoringDb.ps1

Trouble Shooting:

File C:\windows\temp\create-sbsmonitoringdb.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details.
By default we should have the required code execution policy on our SBS servers, this issue is usually related to the way the script was downloaded into the affected server. Open the properties of the download script file from Windows Explorer and click on the Unblock option.

forrás:

http://blogs.technet.com/b/sbs/archive/2011/08/22/how-to-recreate-the-sbsmonitoring-database.aspx

 

Create-SBSMonitoringDb