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 |
|
kirannatt
Yak Posting Veteran
66 Posts |
 Posted - 2006-08-30 : 13:37:01
|
| Hi All,Do we have any way to rollback in SQLServer. I have accidently executed Update Statement in wrong Db.Thanks! |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-08-30 : 13:44:54
|
| did you happen to use begin tran before kicking it off?________________________________________________I am a man, I can change, if I have to, I guess. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 13:59:22
|
| If you weren't in a transaction, then you need to perform a restore.Tara Kizer |
|
|
|
kirannatt
Yak Posting Veteran
66 Posts |
Posted - 2006-08-30 : 14:04:42
|
| I didn't use trans. if i do restore then again i need to do lot of work which I didn't backed up yet |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 14:11:38
|
| You don't have a choice if you want to undo what mistake you made. You can always restore the database to a different name that way you can get at the data and copy to your actual database.Tara Kizer |
|
|
|
|
|
|
SQL Server RollBack