Which of the following statement is used to make sql server resize the database file to its smallest possible size?

Options
- DBCC SHRINKFILE
- DBCC SHRINKDB
- DBCC SQLPERF SHRINKDB


CORRECT ANSWER : DBCC SHRINKFILE

Discussion Board
DBCC SHRINKFILE

DBCC SHRINKFILE is used to make sql server resize the database file to its smallest possible size. This file shrinks the size of the specified data or log file for the current database, or empties a file by moving the data from the specified file to other files in the same filegroup, allowing the file to be removed from the database. You can shrink a file to a size that is less than the size specified when it was created. This resets the minimum file size to the new value.

Prajakta Pandit 03-6-2017 12:03 AM

geography

awsm

Munmun Das 06-19-2015 07:41 AM

excellant

excellant

gur 09-14-2014 10:55 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement