Home Forums SQL Server 7,2000 Administration DBCC shrinkfile error - Msg 8985 RE: DBCC shrinkfile error - Msg 8985
Nicholas Cain
SSC-Dedicated
Points: 33009
More actions
April 14, 2004 at 9:07 am
#502752
Try shrinking it using the fileid (SELECT NAME, FILEID FROM SYSFILES), use the same syntax, just replace the filename with the fileid.