 Dbcc Shrinkfile
DBCC SHRINKFILE
Shrink the size of the current database data / log file or empty a file by moving the data.
Syntax
DBCC SHRINKFILE ( file , EMPTYFILE ) [WITH NO_INFOMSGS]
DBCC SHRINKFILE ( file , target_size
[, {NOTRUNCATE | TRUNCATEONLY }] ) [WITH NO_INFOMSGS ]
Key:
file - 'file_name' or file_id
EMPTYFILE - Migrate data to other files in the same filegroup.
The file can be removed with ALTER DATABASE.
target_size - The size for the file in megabytes.
default = that specified when the file was created, or
the last size used with ALTER DATABASE.(int)
NOTRUNCATE - Free space at the end of the data file is not returned to the OS
(pages are still moved)
TRUNCATEONLY - Release free space at the end of the data file to the OS
(do not move pages)
NO_INFOMSGS - Suppress all information messages (severity 0-10) |