• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

How to open a Server Log file (.ldf)

I want to see what's inside a .ldf file, is there any way / program that would allow me to do so?  Thanx.
0
wilbur88
Asked:
wilbur88
  • 6
  • 3
  • 2
  • +1
3 Solutions
 
Irwin SantosComputer Integration SpecialistCommented:
0
 
Irwin SantosComputer Integration SpecialistCommented:
this is a ptjcb solution from PAQ
--------
This is undocumented by Microsoft....

DBCC log
This command is used to view the transaction log for the specified database.

Syntax:

DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )

PARAMETERS:
   Dbid or dbname - Enter either the dbid or the name of the database
                    in question.

      type - is the type of output:

      0 - minimum information (operation, context, transaction id)

      1 - more information (plus flags, tags, row length, description)

      2 - very detailed information (plus object name, index name,
          page id, slot id)

      3 - full information about each operation

      4 - full information about each operation plus hexadecimal dump
          of the current transaction log's row.

     -1 - full information about each operation plus hexadecimal dump
          of the current transaction log's row, plus Checkpoint Begin,
          DB Version, Max XDESID

by default type = 0

To view the transaction log for the master database, run the following command:

DBCC log (master)
0
 
Irwin SantosComputer Integration SpecialistCommented:
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
Aneesh RetnakaranDatabase AdministratorCommented:
I would suggest you go for LumigentLogExplorer, Apex SQL (www.apexsql.com) , red-gate sql log rescue (http://www.red-gate.com/products/sql_log_rescue/index.htm)

0
 
Anthony PerkinsCommented:
Please post a message in Community Support to have the following duplicate question deleted or the points reduced in both:
http://www.experts-exchange.com/Databases/Q_21831483.html
0
 
wilbur88Author Commented:
I am interested in reading the log, and I've tried the DBCC log command in the sql server earlier.  Besides the operation and object name, it didn't return anything useful to me.  

So I would like to open up the log file (.ldf file), and would like to know whether there's any program would do so.  Is there any suggestions?  Thanx.





0
 
Irwin SantosComputer Integration SpecialistCommented:
uh...have you reviewed the links we posted?
0
 
wilbur88Author Commented:
irwinpks,

yes...I did read over all the replies...and thanx for your suggestions...
I have tried out the DBCC log command before I posted up this question.  

You also suggest Lumigent, and I heard about Lumigent, but it is kind of expensive.  So I would like to look for an alternative way.

Apex SQL and Red-gate SQL log rescue seems to be priced more reasonable, but since I don't need to edit the log file nor restore the database from the log, so I would like to know whether there is an alternative way or any programs that would simply allow me to OPEN and READ the log file (.ldf file) extracted from sql server.

Thanx.



0
 
Irwin SantosComputer Integration SpecialistCommented:
Your choices are limited to the above software. Consider it an investment.
0
 
wilbur88Author Commented:
My original thought is not to install any extra programs on the server, that's why I extracted the log file (.ldf) from the database, and would like to know whether I can open and read .ldf directly.  

em...May be I should consider installing the software onto the server...Thanx
0
 
Irwin SantosComputer Integration SpecialistCommented:
:-)

Cool thank you!
0
 
Anthony PerkinsCommented:
>>My original thought is not to install any extra programs on the server<<
You don't have to and you should not.

>>would like to know whether I can open and read .ldf directly<<
No, you cannot.

>>May be I should consider installing the software onto the server<<
Again, there is no need and you should not.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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