Shrink Database Files
Use this dialog box to view or specify the following options.
Options
Database file
Specify the database file to shrink.
Filegroup name
View the filegroup name of the selected database file.
File ID
View the file ID for the selected database files.
File type
View the file type for the selected database files (for example, data file or log file).
Location
View the location of the selected database files.
Current size
View the current size (in megabytes) of the selected database files.
Space used
View the space used (in megabytes) of the selected database files.
Compress pages and then truncate free space from the file
Compress the database pages and then truncate the free space that is generated by compressing the pages.
Truncate free space from the end of the file
Truncate the free space from the end of the file.
Empty the file (data will migrate to other files in the file group)
Empty the selected database file. The data in the current file will move to other files in the file group.
Shrink file to
Shrink file to a specified size in megabytes.
Shrink the file later
Shrink the file at a specified date and time.
Date
Specify the date on which to shrink the database file.
Time
Specify the time at which to shrink the database file.