Thursday, March 3, 2011

Is there a way to restore a DB in SQL 2005 from LDF only?

Our DB server fell, and we need to restore some of it's DB's. We can find only the LDF file of the needed DB. Is there a tool that can use that for restoring? We're using SQL 2005.

From stackoverflow
  • The LDF file is the transaction log, I doubt you can get anything useful out of it alone.

    You do have backups, right?

  • No. You will also need the .mdf

0 comments:

Post a Comment