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
July 30, 2007 at 10:35 am
#723356
Bapi run
SELECT NAME, FILEID FROM SYSFILES
to get the fileID of the log file, then use that in the DBCC SHRINKFILE script