Online Documentation for SQL Backup for SQL Server

Shrink Database

Shrink Database step allows you to perform database shrinking (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 launch the shrinking operation immediately select Quick_Maintenance_Actions Quick Maintenance Actions | iconServices_ShrinkDatabase Shrink Database popup menu item in the Servers tab.


To perform scheduled shrinking on regular basis you need to include this task into Policy:

1. At Step 2 of the Create Policy wizard click Create new step button and select Shrink Database step type.

2. Also, you can create a new Step Template for further use selecting Shrink Database step at the Templates tab.


Steps of the Shrink Database wizard:

Naming step

Selecting database

Setting options

Performing operation