How do I recover data from SQL Server's log files?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

laststubborn - 29 Nov 2006 08:29 GMT

Dear All,

One of our employee made a mistake and deleted something from database.
I would like to recover that log file without restoring the backup and
the other log files. The reason I want to do this is our database is
getting real time information I cannot shut down the database. Is there
any way to do this please let me know and help me .

Kindly regards

LS

Reply to this Message

Ed Murphy - 29 Nov 2006 09:14 GMT

> One of our employee made a mistake and deleted something from database.
> I would like to recover that log file without restoring the backup and
> the other log files. The reason I want to do this is our database is
> getting real time information I cannot shut down the database. Is there
> any way to do this please let me know and help me .

Restore the backup and log files somewhere else, then copy the
relevant data back into your production database?

Reply to this Message

Erland Sommarskog - 29 Nov 2006 22:56 GMT

You can acquire a log-reader tool like Red Gate's SQL Log Rescue or
Lumigent's Log Explorer. Red Gate appears to have a trial version, so
you could download and get rolling quickly.

Ed's suggestion of backing up the transaction log and restoring the database
elsewhere is also a good approach, if you have the disk space.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message