SHRINK Database

Posted on : 10-01-2012 | By : Devi Prasad | In : Configuring SQL Server, SQL Server Basics, SQL Server Management, Tools


Following are the Steps to SHRINK Database in SQL Server.

1) Connect to the SQL Server in SSMS

2) Expand Databases

3) RightClick on the Database to be shrinked, Click on Tasks then on Shrink.

4) Here you will have two options:

Shrink Database
Shrink Files

Using Database option you can shrink the database as a whole
Files option lets you shrink each file associated with the database seperately.

Shrink Database

Shrink Database

5) Select Database

6) Now in the Shrink Database Popup Click OK

Shrink Database Popup

Shrink Database Popup

Reference : Devi Prasad (

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Your Ad Here

Tags: , , , , , , , , , ,