24. January 2013 · Comments Off on SBSMonitoring database is nearing maximum or hit the 4096MB size on SBS 2008 · Categories: Microsoft · Tags: , , ,

1-27-2013 9-45-40 PM

The Problem….

You receive an Event ID 1827:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

The Technical Bit….

This occurs because the SBSMonitoring database is close to the 4096mMB size or exceeded it.

The Fix….
There are 2 options

Shrink Database
Please follow these steps:
Step 1: Download the following file to the server you are going to be working on:
1. https://www.cubby.com/p/_509b1f65659f4159ab3046e555a69841/updateSBSMonitoring.sql
2. I recommend you save the file to an easy to access path, such as c:windowstemp.
Step 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:
C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLData
5. Once the file backup is completed, start the SQL Server (SBSMONITORING) service.
Step 3: 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:windowstempupdateSBSMonitoring.sql
2.Success will show an output like this:
Changed database context to ‘SBSMonitoring’
(1 rows affected)

Replace with a blank database
If you do not want to keep monitoring data, please follow these steps;
1. Run services.msc.
2. Stop SQL Server(SBSMONITORING) service (To be able to unlock monitoring database files)
3. Change the name of those 2 files in case you will use them in the future or delete them when all ok:
C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDataSBSMonitoring.mdf
C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDataSBSMonitoring_log.ldf
to
C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDataSBSMonitoring-bak.mdf
C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDataSBSMonitoring_log-bak.ldf
4. Download https://www.cubby.com/p/_7d9e8fc3f3f640af8982c2d029259568/sbsmonitoring.zip file.
5. Unzip the zip file and copy those two files to C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLData folder
6. Start the SQL Server(SBSMONITORING) service

 

Comments closed.