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 |
|
simi28
Starting Member
27 Posts |
 Posted - 2007-05-24 : 04:21:28
|
| Hi AllI have updated a field in all records instead of a single record in a table by mistake.i am working in sql 2005.how can I rollback the records.Plz help me me.Thnaks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-24 : 04:22:16
|
| You can't unless you did this inside a transaction and yet to commit it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-24 : 04:48:11
|
| you have to restore from backup. you do have those right?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 09:53:46
|
| Or with third party tools. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-24 : 10:11:47
|
| i've heard about those once or twice but they were a bit of black magic to me... so i didn't dare use them._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-24 : 10:41:49
|
| simi28: Note that you can restore a backup to a new, temporary, database and copy the messed-up data across to your Live database. (You don't have to restore back the whole Live database!)If your Recovery Model is set to FULL then you will also be able to restore back to just before the accident. if the Recovery Model is SIMPLE then you can only restore to your last Full or Differential backup.Kristen |
|
|
|
|
|
|
how to rollback records