如何从.ldf文件获取日志详细信息？ [英] How to get log details from .ldf file ?

问题描述

如何使用用户名/ id在服务器上运行Update，Insert和Delete SQL的日志记录信息。我只有.ldf和.mdf文件。

我正在使用SQL Server 2008 R2。有免费工具吗？



我尝试过：



我已经尝试过SQL Server 2008 R2 SQL Server日志但是没有提供所有信息。

How can I get the logging information of Update, Insert and Delete SQL ran on server with the user name/id. I have only .ldf and .mdf file.
I am using SQL Server 2008 R2. Is there any free tool?

What I have tried:

I have tried SQL Server 2008 R2 SQL Server Log but that is not giving all information.

推荐答案

谷歌建议您需要第三方工具来执行此操作。这告诉你如何阅读日志：



https://www.sqlshack.com/how-to-read-a-sql-server-transaction-log/ [ ^ ]



但是更多信息，我认为你需要买东西

A google suggests you need a third party tool to do this. This tells you how to read the log:

https://www.sqlshack.com/how-to-read-a-sql-server-transaction-log/[^]

But for more info, I think you need to buy something

这篇关于如何从.ldf文件获取日志详细信息？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！