If the update was committed, there is no way to recover the data unless you
have a backup copy of the database or of the table individually. You might want
to implement some kind of backup strategy to allow easy recovery from a similar
future situation. Cheers!
Subject: URGENT: Please help with an recovery option...
From: Nnoor_at_cris.com (nnoor)
Date: 8/26/98 1:53 PM EST
Message-id: <6s1lj4$bil_at_chronicle.concentric.net>
>I am still kicking myself... I ran an update query on a table
>which also modified some data which it wasn't supposed to (failed
>to include an option in the where clause). Is there any way to
>get teh data to the way it was? Any type of roll back? Anything?
>
>Thanks and Regards,
>Nasir (nnoor_at_cris.com)
>
Received on Wed Aug 26 1998 - 22:10:49 CDT
