How to reduce the size of the MessageStats Database files after aging or purging data. (4280828)

After deleting data from the MessageStats database the size on disk of the database stays the same. How can I reduce the size of the MessageStats Database.

This is a function of Microsoft SQL Server. Deleting data from a database only free's up space within the database files it does not reduce the size on disk of the database files. Unless the database files are shrunk by the DBA.

For SQL Server 2005 / 2008 / 2008 R2

1. Open Microsoft SQL Server Management Studio
2. Expand Databases in Object Explorer
3. Right click the MessageStats Database and select Tasks | Shrink | Database
4. Click OK

Note: The Default setting shrinks the Database files to the last allocated extent, for more detailed information click the help button at the top of the "Shrink Database" dialog box.