Moving or Deleting the SBS Monitoring database in SBS 2008
By default the SBS Monitoring database resides under
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
which can grow to more than 4GB of size. This can cause disk space problems on the server and there is no particular need of it to be on the system drive. Here are the steps to move it to another partition.
Stop any backup you may be running in SBS 2008
- Now navigate to C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data
- Open the SQL Server Management Studio Express and connect to the SBSMonitoring database.SERVER\SBSMONITORING
- Now we have a couple of options based on what we want to do
- If we want to flush the database and start with a clean one of a normal size you can delete the SBSMonitoring.mdf and SBSMonitoring_Log.Ldf files. After they are deleted we need to replace them with the same database files but files but emptied. You can download them from here. This is all you need to do and can move to step 6.
- If we want to move the database to another partition and still use it, now that you have stopped both of the services mentioned above. Move the SBSMonitoring.mdf and SBSMonitoring_Log.Ldf files to another partition.
Right click the database -> Tasks -> Detach. Click Ok to detach the database. If you receive this error : Msg 3701, Level 16, State 1, ServerName\SBSMonitoring, Line 1
Cannot detach the database ‘SBSMonitoring’ because it is currently in use.
Go to Services again and restart the SQL ( SBSMONITORING ) service. Click Ok and the database should detach now. Right click the Databases folder now and click Attach. On Databases to attach : click Add and browse to the new location of the database. You can now proceed to step 6.
- Now go back and restart/start the SQL Server ( SBSMONITORING ) service and Windows SBS Manager service
Checks ! You can always check if the changes you just did are working. Generate a report, email it and see if everything works fine. If not use the following guide.