|
Category: SQL Server
view more software Tips and Tricks
Updated: 10/15/2013 08:10 AM
Author: Shiju Mathews Status: Resolved. |
|
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 |