Category: SQL Server
view more software Tips and Tricks
Updated: 10/15/2013 08:10 AM
Author: Shiju Mathews
Note: It is recommended to create a full back up of the database that is going to shrink
Assume that you have installed AdventureWorks2008R2 in your database.
You can shrink the database using SSMS
Right click on the database name.
Select Tasks -> Shrink -> Database
Then click OK!
Usually open the Windows Explorer directory containing the database files so I can immediately see the effect.
Also you can do this by TSQL