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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-08-30 : 05:11:46
|
| by accident i happened to update all the rows of a table (by using the update table statement) , it has 20,000 -25,000 rows in it is there any way i can rollback the updation ???thnxs,harsh |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-08-30 : 06:03:19
|
| Hi... It's hard to rollback transactions once they are commited. I have two suggestions:1) Restore a backup2) Use a third part log recovery tool (for example Lumigent Log Explorer). |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-08-30 : 06:36:24
|
| don't we have some thing like archiving log files like that in oracle for in time recovery??thnxs anyways..harsh |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-30 : 15:45:38
|
| If you are taking regular transaction backups then you most certainly can do a point in time recovery. Restore the db backup with no recovery,restore the log(s) with no recovery and for the log that spans the delete issue a STOPAT in the restore log and RECOVERYSee RESTORE in BOLHTHJasper Smith |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-08-31 : 04:45:35
|
thnxs alot..harsh |
|
|
|
|
|
|
rollback!!