Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL database is crashed


Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file.

Is it possible to bring the DB (.MDF) in the old backup to Live standard using the new/latest Log file?
If so, how? Any help is truly appreciated.

Former Member
Former Member replied

Ok, If your database is not functional now, then you can't take tail log backup.
In that case, try the steps given below:

* Detach your database
* Copy your LDF File to a new location
* Attach MDF File without providing LDF file..

Test whether this works or not. If not then can try the tool SQL Server Recovery Toolbox. It is possible you will be able to help.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question