How to shrink Sql Server Database?

The Enterprise Management studio provides an option to shrink the database.


Step 1: Open Enterprise Management Studio (i am using sql server 2008) and select database, right click and choose Tasks>Shrink



Step 2: In the appearing dialogue press Ok to start the shrink process.


Leave a Reply

Your email address will not be published. Required fields are marked *