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, 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 . [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

yes better to have a third party tool
Apex SQL Log is a good tool http://www.apexsql.com/sql_tools_log.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

Hi , you can also try LOG EXPLORER http://www.lumigent.com</a>, a bit expensive one[<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />] AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS 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
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

I would agree with using third party tools here, as you’re looking to the log file for probing the transaction. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>