Use this dialog box to shrink the size of a database.
Options
-
Database
-
Displays the name of the selected database.
-
Current allocated space
-
Displays the total used and unused space for the selected database.
-
Available free space
-
Displays the sum of free space in the log and data files of the selected database.
-
Reorganize files before releasing unused space
-
Selecting this option is equivalent to executing DBCC SHRINKDATABASE specifying a target percent option. Clearing this option is equivalent to executing DBCC SHRINKDATABASE with TRUNCATEONLY option. By default, this option is not selected when the dialog is opened. If this option is selected, the user must specify a target percent option.
-
Maximum free space in files after shrinking
-
Enter the maximum percentage of free space to be left in the database files after the database has been shrunk. Permissible values are between 0 and 99.
See Also