By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,728 Members | 2,480 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,728 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 29 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?
Nov 29 '06 #2

P: n/a
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
Nov 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.