Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 40852
  • Last Modified:

How to Open Or read SQL Server log file .ldf)

Dear Sir,

When ever we create database from sql server, it's create two file. (1) .mdf (2) .ldf.
I want to see what's available inside the .ldf file.
Through program (visula basic or any other way). Can you help me.


Best Regards.
M. Md. Rafeek
0
md_yasheen
Asked:
md_yasheen
  • 3
  • 2
  • 2
1 Solution
 
LowfatspreadCommented:
I'm not aware of anything to do this...

why are you even asking ... ?
the log format would be subject to potential change for each microsoft upgrade/fix....

alternatively the only consistent way of seeing what's in the logs

is to do some point in time restores and then detect the changes "normally" in your data tables...

0
 
arbertCommented:
There is a tool called LogExplorer from lumigent that will allow this http://www.lumigent.com.  There are also several other packages that are starting to show up on the market--netIQ also has one.  LogExplorer will allow you to conditionally commit or rollback transactions.  Other than that, there isn't too much that you can do with the ldf (log file) yourself.

Brett
0
 
Ralf KlattPrincipal ConsultantCommented:
Hi,

@Lowfatspread ... why do hook to a question that you admit not to be able to answer?

@arbert ... you're ABSOLUTELY right!!!

@md_yasheen ... There is no easy way out if you want to read the transaction logs for whatever reason. The transaction log architecture is proprietary to Microsoft and is not published. However, there is an undocumented DBCC LOG command that lets you see the records in transaction log. Here is an example:

DBCC LOG (Your_Database_Name, 2)

As arbert postetd -> theress a third party tool called Log Explorer by ---> Lumigent <---, that helps you read transaction logs and do stuff like recovering data, auditing database etc.


Best regards, Raisor
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LowfatspreadCommented:
raisor , for the challenge and the learning opportunities this creates...
          and of course because the idea of wanting to read the log files is so OTT, that there
          must be better ways of achieving what MD_yasheen thinks he needs to do...  
 
0
 
Ralf KlattPrincipal ConsultantCommented:
Hi,

Yeah, I see what you mean -> but to be honest, I do not always say what I see without taking time off for reflection before -> and I don't even want to talk about the files that I looked at in the early years ;-)) -> ...

... my believe is: everyone goes its own way -> if md_yasheen gets closer to reading out any log file while reading out a transaction log -> well, then we have one more professional that knows to explain how to read lol files!

@md_yasheen ... can you please explain why it is important for you to read LDF files?


Best regards, Raisor
0
 
LowfatspreadCommented:
;-)
yes i'd want to know if md succeeds and manages to understand a particular log file version as well, its bound to come in handy at some stage...

best regards low
0
 
arbertCommented:
Ya, log explorer is handy (if not pricy).  Actually, we had a Microsoft Engineer on site 3days last week and he highly recommended it (we had already used it in the past).  Just like any tool though, it can be dangerous too....
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now