The enumeration contains values that are used to specify the method that is used shrink a database file.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
|Data in pages located at the end of a file is moved to pages earlier in the file. Files are truncated to reflect allocated space.|
|Migrates all of the data from the referenced file to other files in the same filegroup. (DataFileand LogFile objects only).|
|Data in pages located at the end of a file is moved to pages earlier in the file.|
|Data distribution is not affected. Files are truncated to reflect allocated space, recovering free space at the end of any file.|