Home » Blog » Reply » Reply To: SQL Server log file does not match the primary file

Reply To: SQL Server log file does not match the primary file

Andrew Jackson ~ Modified: July 4th, 2015 ~ ~ 1 Minute Reading

Home › Forums › SQL Server log file does not match the primary file › Reply To: SQL Server log file does not match the primary file

July 4, 2015 at 5:10 am #318 Score: 0
Andrew Jackson
Moderator
1 pt

Hi
The below Error MSGs I got

Error: 5173, which shows “One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup”

Error: 17207, Severity: 16, State: 1.
FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file ‘x:\xxxx\LOGS\xxxx_log.ldf’. Diagnose and correct the operating system error, and retry the operation.

Please Help Me