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

[laststubborn]

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

[Ed Murphy]

laststubborn wrote:

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?

[Erland Sommarskog]

laststubborn (ar*********@gmail.com) writes:

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 .

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.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx