Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delila
Starting Member
11 Posts |
 Posted - 2011-08-03 : 07:40:13
|
| Hello,Is there any way the Undo an update statement (no transaction was used)i know i'm looking for a miracle |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-03 : 07:51:17
|
| Do you have a backup ?PBUH |
 |
|
|
Delila
Starting Member
11 Posts |
Posted - 2011-08-03 : 08:04:55
|
quote:
Originally posted by Sachin.Nand
Do you have a backup ?PBUH
Yes but a full back not in time |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-03 : 08:05:41
|
| do you have some kind of audit mechanism like change data capture or audit/history tables?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-08-03 : 08:34:39
|
quote:
Originally posted by Delila
quote:
Originally posted by Sachin.Nand
Do you have a backup ?PBUH
Yes but a full back not in time
Not sure if this will work.First take a tailog backup.Restore the full backup on a NEW database.restore all the log backup's with norecovery option including the tail log backup.When you are restoring the last log backup mention the stopat option till the time where you had updated the table.PBUH |
|
|
|
|
|
|
Roll Back