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)"
No comments:
Post a Comment