从Sql Server恢复已删除的数据 [英] Recovery deleted data from Sql Server

问题描述

我错误地从SQL表中删除了一些数据。但是，

我需要将数据返回到该表。我用直接删除查询。

怎么能把它拿回去？



任何人都请帮帮我！

Hi,


I have wrongly deleted some of the data from a SQL Table. But,
i need that Data back to that table. I used direct delete query.
how can i get it back?

Anyone please help me out!

推荐答案

你可以利用 fn_dblog 的功能sql server。



参考以下文章的使用情况&更多关于fn_dbLog。

fn_dblog（）函数文档 [ ^ ]

如何从SQL Server恢复已删除的数据 [ ^ ]

恢复已删除的记录在sql server [ ^ ]

如何从SQL Server表中恢复已删除的行？ [ ^ ]



希望它有所帮助。

Hi,

you can make use of fn_dblog function of the sql server.

refer below articles for usage & more on fn_dbLog.
fn_dblog( ) function documentation[^]
How to recover deleted data from SQL Server[^]
recover deleted records in sql server[^]
How to recover deleted rows from SQL server table?[^]

hope it helps.

这篇关于从Sql Server恢复已删除的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！