Andreas G. (AndreasG (AT) discussions (DOT) microsoft.com) writes:
Quote:
my company makes a CAE tool which stores it's data on MS SQL Server.
Recently one of our customers had a data loss, and he made a copy of this
system and wants this system being analyzed.
For getting an idea of the happenings I need a tool for extracting a
sequence of "DELETE from Tablename Where ...." ´within a certain period of
time.
Does Microsoft have any tools, preferably as MSDN download, for
converting a ldf file (which was created in full recovery model) into
human readable content? |
There is, or was, third-party tools out there that could do this. I'm
uncertain how many of these that still are in business. It seems that
Apex still have something: http://www.apexsql.com/sql_tools_log.asp.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx