SQL SERVER2008 History Log Query

There is a need to find a tool to query the SQL Server history operation log, such as accidental deletion, misoperation, etc., online search a lot, not a reliable. Of course, exclude themselves from writing SQL records operation log, I do not understand the SQL language. There are tools available to recommend, thank you.

1. Log Explorer for SQL Server

   Support to SQL2005, the above is not supported.

2. SQL Server comes with management--sql server logs

   Logged in and error logs

3. Powerful SQL Server Profiler

   Mainly as a real-time analysis process or troubleshooting to use, can not query the history log, unless always open

4. Query transaction log, restore LSN, this too high-end

   Refer to http://blog.csdn.net/kevinsqlserver/article/details/7800628
   

5. More powerful third-party tools, ApexSQL Log,

   Display effect is good, easy to understand, but the trial can only query the last 10 rows of log, to solve

6. SQL Server's own auditing capabilities

   Available, I feel most reliable at the moment. Simple configuration is required and is not audited by default.

   Http://technet.microsoft.com/zh-cn/library/cc280386.aspx
   

7. Expect Microsoft to be able to open a tool that can view the LDF, otherwise this file will be used

This article from "CLOUD" blog, declined reprint!