在sql server中恢复数据 [英] recover data in sql server

问题描述

如何从偶然的UPDATE和DELETE操作中恢复SQL Server数据...........

解决方案

取决于你需要什么和多少恢复。



恢复和恢复概述可以帮助你 - 还原和恢复概述 [ ^ ]。

恢复模型 [ ^ ]也可以帮助你。

您可以使用fn_dblog（）函数查看上次更新和删除的记录。但是fn_dblog（）是一个未记录的函数，但它可以帮助您跟踪事务日志活动。请参阅此处了解如何使用它 http://www.sqlserverlogexplorer.com/reading-sql-server-事务日志/

How to recover SQL Server data from accidental UPDATE and DELETE operations...........

解决方案

Depends what and how much you need to restore.

Restore and Recovery overview should help you - Restore and Recovery Overview[^].
Recovery models[^] too can help you.

You can use fn_dblog() function to view last updated and deleted records. however the fn_dblog() is an undocumented function but it helps you can track transaction log activities. see here for how to use it http://www.sqlserverlogexplorer.com/reading-sql-server-transaction-logs/

这篇关于在sql server中恢复数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！