SQL Server > Database

Shrink database in SQL Server

How to shrink the database in SQL Server?

To shrink the database to release unused space by the database, we can right click the database to Shrink and go to Tasks > Shrink > Database. This opens the Shrink Database dialog box.

By default, it shows the currently allocated space and available free space that can be released. Now click on OK and that will release the available free space from the database file.

Views: 7615 | Post Order: 13