检查数据事务事件 [英] Check Data Transaction event

问题描述

Hello All，

Hello All,

我有一个情况

我们有SQL服务器2012年，事务日志设置为简单

We have SQL server 2012 and Transaction Log is set to Simple

3天前的某个地方由于某些活动，很少有选择性数据（范围内）从数据库中删除。

Somewhere 3 days ago due to some activity few selective Data (In Range) got deleted from DB.

但是我们需要识别已删除记录的IP或机器 

However we need to identify the IP or Machine from which the records have been deleted 

请建议我们如何做同样的事情

Please suggest how can we do the same

问候

Navin Tenani

Navin Tenani

推荐答案

如果您没有记录/审核此类信息，那么您之后就无法获得这些信息。

If you don't log/Audit such informations, then you can't get them afterwards.

这篇关于检查数据事务事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！