Shrinkfile Error

[sendba]

Hi all,

I have archived 100 Million records and wanted to shrink the data file where it contains 15 Gb in order to free up some space on the drive. When I execute DBCC SHRINKFILE (NAME, 20000) I get the below error

File ID 5 of database ID 9 cannot be shrunk as it is either being shrunk by another process or is empty.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

Please let me know if someone came across this error and how to fix it.

Thanks

Sen

 

[sendba]

I figured out a solution to this issue but simply growing the file by 50 MB and reissuing the DBCC shrink command and it started to shrink.

Thanks