how can i see the content of my ldf file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how can i see the content of my ldf file

i already stopped the sql services, and copied the ldf file to another hard drive on the sql server.
i need to see the details inside this file, looking to see what happened with some transactions yesterday.
the sql logs on the enterprise manager won’t show me anything, but the database is setup to use full logging. please help

Hi,<br />it will show you inside of log – dbcc log(pubs) but i think you have to perform things with third party tool like logpi , log explorer .<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
yes better to have a third party tool
Apex SQL Log is a good tool —————————————-
Cast your vote

Hi ,<br /><br />you can also try LOG EXPLORER<br /<a target="_blank" href=></a>, a bit expensive one[<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />AKTHAR DILMOHAMUD<br />65 BENARES ST<br />PORT LOUIS<br />MAURITIUS
All third-party tools are nice and probably would do the job. The only disadvantage with them is, they would have to be installed *before* this has happened. Now, after the fact, AFAIK they are pretty useless here. Probably your only chance is to examine the log file via DBCC LOG as Hemantgiri already mentioned. However, you will soon realize that the information you find there is pretty cryptic. —
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

I would agree with using third party tools here, as you’re looking to the log file for probing the transaction. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.