Hi, By mistake I have updated all the rows of a table with same data for certain columns (missed the statement that contains where clause). Are there any free tools that can help me to restore old data for these rows.
+1
A:
If the recovery model is full then it is possible to go back in time. Other than that, I don't think it's possible to recover that data. Unless you backup your data regularly.
See How to: Restore to a Point in Time (SQL Server Management Studio)
Denis Valeev
2010-09-07 08:03:48
A:
This link might be useful: Minimizing data loss when accidents happens
It has a list of a couple of tools as well (though not sure if they're free or how well they work).
ho1
2010-09-07 08:05:46