I have updated 100 rows on one column which have different values in it e.g. 3,5,2,1,4,5 etc but i have wrongly updated all with value 9 and also committed it. is there any way that i can revert the previous values to that column? iam using sql server r2
Asked
Active
Viewed 172 times
0
-
1No, unless you log every modification. You can rollback before commiting, but once commited, values are overwritten. Use backups. – xlecoustillier Mar 23 '15 at 11:07
-
yes thanks its a good idea – muhammad arslan Tariq Mar 23 '15 at 11:09
-
Also if that column contain value of calculated field then also you can re-update those columns and rows with appropriate query . – KumarHarsh Mar 23 '15 at 12:14
1 Answers
0
SQL Server doesn’t support this but in some cases it is possible to recover data by reading transaction log. This works if database was in full recovery mode and 3rd party tools like ApexSQL Log or Log Rescue are needed. There is also a way to read t-log using DBCC LOG command but it too difficult.
Community
- 1
- 1
Jameel Grand
- 2,131
- 14
- 31