SQL Server gives error 8985 – "Could not locate file XXXXXXX in sysfiles"
Recently we came across this scenario: – A transaction log was growing fast in size. – To free up space we decided to: o Backup the transaction log o Shrink the log file to reclaim lost space from the hard disk The backup log command worked as expected, however the shrinking of the transaction log gave this error: SQL error 8985 – Could not locate file XXXXXXX in sysfiles We ran these three queries to find out what kind of inconsistency there was: – DBCC FILEHEADER ( dbname ) This query returned…( read more )
Excerpt from:
SQL Server gives error 8985 – "Could not locate file XXXXXXX in sysfiles"
