Return
-
Title
Does purging the database shrink the size? -
Description
Does purging the database shrink the size?
-
Resolution
No purging the data from the database does not shrink the size of the file. Please see below for further info on how to shrink the DB.
After the data has been purged from the MessageStats database, please launch SQL Enterprise Manager, highlight the MessageStats Database and then select the Tools Menu, SQL Query Analyzer. Type the following or copy/paste to the center window in SQL Query Analyzer to shrink the DB and then use the other command to shrink the transactions log.
DBCC SHRINKDATABASE (MessageStats, 30)
DBCC SHRINKFILE (2, 50)
Once typed in click the green arrow icon on the menu bar above to execute.