View Single Post
  #1 (permalink)  
Old July 9th, 2003, 04:43 PM
VBAHole22 VBAHole22 is offline
Authorized User
 
Join Date: Jun 2003
Location: Richmond, VA, USA.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Disaster Recovery

Okay so I wanted to copy some stored procedures from one db to another db within SQL server 2k. I did manage to copy the procs but in the process I wiped out all of the data in a few tables. The structure is still there but the data is gone! Is there a way to roll back the transaction to get the data from the tables back? I don't do any regular backups like I should but this only happened an hour ago and there are no other transactions going on on this server right now.

I see on a lot of other websites that sql server data can be recovered from transaction logs but nodoby says HOW to do it.

Any suggestions?
Reply With Quote