Dbcc In Sql Server 2008. Consider the following scenario in microsoft sql server 2008 or in microsoft sql server 2008 r2. It shrinks (if possible) the file with logical name 'reportserver' to the target size of 500 mb olaf helper [ blog] [ xing] [ mvp] · hi, what is meaning of below commanrd in in sql.

The final sum of all used_space will be 1.2 tb. This command has no impact on performance or data. Go dbcc shrinkfile (datafile1, 7);