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 |
|
PaulyWally
Starting Member
1 Post |
 Posted - 2007-05-10 : 16:51:25
|
| Someone messed up big time here, and I'm not the DBA. So I'm trying my best.An UPDATE statement was run without a BEGIN TRANS... and also without a WHERE clause. So, every one of the records in a particular row was updated.I told him to leave everything alone... which means that query analyzer is still open (and where he left it) on his computer.Any way we can fix this?Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-10 : 16:55:22
|
| You can't rollback the transaction since BEGIN TRAN wasn't used and also since by default Query Analyzer implicitly commits the transactions. You'll need to restore from backups.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-11 : 05:19:34
|
| ... or you can restore a backup to a new, temporary, database and then update the Live database using the data from the Temporary database.Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-11 : 09:56:01
|
| Can recover with third party tools if you don't have good backup. |
|
|
|
|
|
|
Any way to rollback this transaction?