Is there a way to restore a DB in SQL 2005 from LDF only?
Our DB server crashed and we need to restore some of its DBs. We can only find the LDF file of the required database. Is there a tool that can use this to recover? We are using SQL 2005.
0
Lea Cohen
source
to share
2 answers
Not. You will also need .mdf
+2
Mitch wheat
source
to share
The LDF file is a transaction log, I doubt you can get anything useful out of it.
You have backups, right?
0
Lasse Vågsæther Karlsen
source
to share