开发者

Any free tool for SQL server log recovery<SQL 2005)

开发者 https://www.devze.com 2023-01-15 06:40 出处:网络
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开发

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.


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)

0

精彩评论

暂无评论...
验证码 换一张
取 消