Restore database from bak and ldf files

469 views Asked by At

I just created database from an old bak file and need to recover database to latest version but I don't have recent backups or mdf file but only ldf file. How can I recover DB from from only ldf file?

1

There are 1 answers

0
Sander On

A LDF file is a log of all transactions made on the database. As it doesn't contain any data itself, it's not possible to recover a database with only the log file. You can use a log file for database recovery, but only in combination with the data itself.