DBCC Shrinkfile with emptyfile help requested
Posted on 2007-07-26
In Microsoft SQL Server we deleted a lot of data in a column in our table by updating with NULLS, which has not been reclaimed.
I am currently running dbcc shrinkfile (datafile, emptyfile) to empty the file into another on the same drive.
It's working and it's removing data from the primary data file and moving it to the second data file.
However, the system will run out of disk space before It's completed.
How do I shrink the bulk-logged database file while the dbcc shrinkfile emptyfile is running?