Solved

how i can read sql log file

Posted on 2008-06-12
5
1,147 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 250 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 250 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows 10 powershell/cmd/bash alternatives? 11 58
Create workstation base image 4 38
How to safely test out TFTP server software 12 65
C# LINQ ForEach() question 6 28
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
Using Adobe Premiere Pro, the viewer will learn how to set up a sequence with proper settings, importing pictures, rendering, and exporting the finished product.

773 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