Subject: Restoring a table
Posted By: anandham Post Date: 11/7/2005 10:04:54 AM
Hi,
  I have mistakenly updated a table completely for a particular column without any where clause condition. So all my data in that column for that table got updated. I wanted to retrieve the data for that column. Please help me in this regard. It's really urgent. I have a backup which is around 2 weeks old.
If I can do a immediate roll back it'll be fine. otherwise I have to restore from the already existing backup. Please help me in this regard.
thanks
anandham

Prem Anandh P.
Ambition Never comes to an End
Reply By: robprell Reply Date: 11/11/2005 11:39:32 PM
I think you need ot restore an old database to another location, then pull the single tables data from that restore.  I don't think what you want to do is practical.  Once you commit data its committed and can't be rolled back.


Go to topic 36508

Return to index page 437
Return to index page 436
Return to index page 435
Return to index page 434
Return to index page 433
Return to index page 432
Return to index page 431
Return to index page 430
Return to index page 429
Return to index page 428