dbTalk Databases Forums  

sql server log file analysis tool

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss sql server log file analysis tool in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Andreas G.
 
Posts: n/a

Default sql server log file analysis tool - 04-22-2010 , 11:03 AM






Hi all,

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?
--
42 is the answer to which question?

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: sql server log file analysis tool - 04-22-2010 , 05:35 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.