Sunday, February 20, 2011

SBS 2003 shrink SBSMonitoring database

Execute the following commands to shrink the databases (suggest backing up beforehand):

osql -S "SERVER\SBSMONITORING" -E -Q"USE SBSMONITORING; DBCC SHRINKFILE (SBSMonitoring, 1)"


osql -S "SERVER\SBSMONITORING" -E -Q"USE SBSMONITORING; DBCC SHRINKFILE (SBSMonitoring_log, 1)"


osql -S "SERVER\SBSMONITORING" -E -Q"USE SBSMONITORING; DBCC SHRINKDATABASE (SBSMonitoring, 10)"