Online Documentation for SQL Manager for SQL server

Shrink Database


Shrink Database Wizard allows you to perform database shrinking on your SQL Server system (the DBCC SHRINKDATABASE and SHRINKFILE Transact-SQL statements are issued).

 

This operation is used to reduce any file within the database to remove unused pages. Both data and transaction log files can be reduced, or shrunk.

 

To run the wizard, select the Services | iconServices_ShrinkDatabase Shrink Database... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | iconServices_ShrinkDatabase Shrink Database... item of the context menu.

 

menuShrinkDatabase

 

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.

 

 


See also:

Using templates