SBS MSSQL$SBSMONITORING 1105 Event Error SQL

You recieve the following error in EventViewer with regards to “MSSQL$SBSMONITORING”, Event ID: 1105

Description:
Could not allocate space for object ‘dbo.EventLog’.’PK_EventLog’ in database ‘SBSMonitoring’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
This is generally related to the size of the the database (Exceeds 4GB)
To Fix this follow the below instructions:

  1. Download this file and save in C Root
  2. Goto Start, Run, Type Services.msc
  3. Right Click on “SQL Server (SBSMONITORING)” and click stop
  4. Goto Directory contaning Databases in my case this is:
    C:\Program Files\Microsoft SQL Server\MSSQL10_50.SBSMONITORING\MSSQL\DATA
  5. Go up a directory, and copy the Folder “DATA” to another location as a backup
  6. Go Back to services.msc and start database again.
  7. Open an elevated command prompt and type:
    Sqlcmd -S %computername%\SBSMonitoring -E  -i c:\updateSBSMonitoring.sql
  8. This can take more than 10 mins dependant on hardware and should display:
    “Changed database context to ‘SBSMonitoring’ (1 rows affected)”
  9. This error should now be fixed, Restart server, assuming that no other SQL error occur with relation to the SBS Monitoring Database, Delete backup.

This article is a shortened version of: 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

 

Source: http://leechilds.co.uk

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s