Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to restore a table in SQL server 2000

Status
Not open for further replies.

cctrinh

MIS
Feb 2, 2001
25
US
Hello,

Today, I accidently delete all the data from a table. I was wondering is it possible to restore a table's data from the transaction log. I don't want to restore from last night backup.
I just need to restore the data for one table. I hope someone can give me some assistance on this. Thank you in advance for your help.
 
you can't restore just one table from any backup. If you still have the log file that the delete occured in you can download and purchase a product called Log Explorer by lumigent. It will read you transaction log and you will be able to recreate the delete as an insert and get your data back. It's one of the best products I use.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top