Answer the question
In order to leave comments, you need to log in
How to restore .LDF in SQL?
Sql Server 2016. Wanted to move location of MDF and LDF files to another folder. Did moved only MDF configured default storage to a new folder. Then he mistakenly attached the MDF base without LDF (since there was no LDF in the new folder) and he created a new LDF, now the old LDF is not connected, it gives an error:
Ошибка: 5173, серьезность: 16, состояние: 2.
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.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question