raresql.com
SQL SERVER – DBCC SHRINKFILE for FILESTREAM containers requires EMPTYFILE option and does not allow any other options.
DBCC SHRINKFILE for FILESTREAM containers requires EMPTYFILE option and does not allow any other options is one of the error messages shipped with SQL Server 2012. It happens due to the new feature…