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:47 am
#502768
Run the following, replace DBNAME with your database name and FILEID with the file id.
BACKUP LOG DBNAME WITH NO_LOG
GO
USE DBNAME
DBCC SHRINKFILE (FILEID, 128, TRUNCATEONLY)