Shrink Database (General Page)

  • Article

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

Reference

Shrink File (General Page)

Other Resources

DBCC SHRINKDATABASE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance