Posted by Erland Sommarskog on 11/29/06 22:56

laststubborn (arafatsalih@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, 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

• Next in forum: Re: Aggregate functions and locking
• Prev in forum: Re: Aggregate functions and locking
• Thread view: Re: How do I recover data from SQL Server's log files?

[Reply to this message]