Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how i can read sql log file

Posted on 2008-06-12
5
Medium Priority
?
1,152 Views
Last Modified: 2013-12-12
When ever we create database from sql server, it's create two file.   I want to see what's available inside the .ldf file.  Through program (visula basic or any other way). Can you help me.

i want to tranjection audit tool
0
Comment
Question by:JAYANSPX
5 Comments
 
LVL 7

Accepted Solution

by:
maradam earned 1000 total points
ID: 21776234
Hello,

There is a function fn_dblog, but info it returns is not too human-readable. You will need third party tool.
For example this one http://www.apexsql.com/sql_tools_log.asp
There are some other companies making such tools, like Lumigent and Red Gate
0
 
LVL 2

Expert Comment

by:avishkarm
ID: 21776728
Every database has at least 2 files, a primary file and a transaction log file, and at least one filegroup. A maximum of 32,767 files and 32,767 filegroups can be specified for each database.Log files hold all the log information that is used to recover the database. There must be at least one log file for each database, although there can be more than one.
I don't recommend you try to analyze the log file, If you reaaly require to anaylze then you can use SQL Profiler.
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 1000 total points
ID: 21777612
YOu're not going to be able to do it through your own c ustom code....the only real way to do it is to buy a 3rd party tool such as Lumignet Log Explorer to read it...its going to show transactions that have been committed, but not select statements.

I know you're thinking "if they can do it then why can't I"....they had help from MS ( and a lot of documentation that is only available to indpendent software providers to let them figure out how to do it.
0
 
LVL 8

Expert Comment

by:MOA81
ID: 22949513
I agree with chapmandew
They got help from MS
To be able to understand what's going on with the transaction log you'll need apply for a license called
On-Disk Structures document
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
Eseutil Hard Recovery is part of exchange tool and ensures Exchange mailbox data recovery when mailbox gets corrupt due to some problem on Exchange server.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question