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 | 
Shrink Database... main menu item, or right-click the database alias in the DB Explorer tree and select the Tasks | Shrink Database... item of the context menu.
- Selecting database and setting shrink mode
- Defining shrink action for database
- Defining shrink action for files
- Shrinking database
|
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: |
