Online Documentation for SQL Manager for SQL server
Defining shrink action for files
This step of the wizard provides you with information on the allocated and free space, and allows you to specify the shrink action for each of the database files.
Shrink action for file
Release unused space
The free unused space is released explicitly (default).
Reorganize pages before releasing unused space
This action causes the pages to be reorganized before unused space is released.
Empty file by migrating the data to other file in the same filegroup
This action migrates all data from the selected file to other files in the same filegroup. In this case placing data on the file is not allowed.
If necessary, you can change the default value of the target_size edit-box to enforce shrinking the file to the specified size.
When you are done, click the Next button to proceed to the Shrinking database step of the wizard.