O
O
Orkhan Mammadov2020-10-28 01:39:56
Database administration
Orkhan Mammadov, 2020-10-28 01:39:56

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

1 answer(s)
K
Konstantin Tsvetkov, 2020-10-28
@orxan7m

ms+sql+restore+mdf+without+ldf

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question