Viewing a Log File 
Author Message
 Viewing a Log File
Hi, All.

It maybe a very simple stuff for all of you SQL gurus....anyhow, I am trying
to view a transaction log file (.LDF) for a database.  How can I view it?

Thanx.

SK



Sat, 29 May 2004 06:28:13 GMT
 Viewing a Log File

Sean,

From sqlserver side there isnt any provision for actual "viewing".
You can try lumigent explorer from www.lumigent.com

Dinesh.


Quote:
> Hi, All.

> It maybe a very simple stuff for all of you SQL gurus....anyhow, I am
trying
> to view a transaction log file (.LDF) for a database.  How can I view it?

> Thanx.

> SK



Sat, 29 May 2004 06:37:07 GMT
 Viewing a Log File
If no actual viewing, I am just wondering what the log file is for?  When do
we make a good use of it?

SK



Quote:
> Sean,

> From sqlserver side there isnt any provision for actual "viewing".
> You can try lumigent explorer from www.lumigent.com

> Dinesh.



> > Hi, All.

> > It maybe a very simple stuff for all of you SQL gurus....anyhow, I am
> trying
> > to view a transaction log file (.LDF) for a database.  How can I view
it?

> > Thanx.

> > SK



Sat, 29 May 2004 07:38:41 GMT
 Viewing a Log File
Any time you do anything in SQL Server you make good use of the log file.
Look up "Transaction Logs" in BOL for more details.

Tim


Quote:
> If no actual viewing, I am just wondering what the log file is for?  When
do
> we make a good use of it?

> SK



> > Sean,

> > From sqlserver side there isnt any provision for actual "viewing".
> > You can try lumigent explorer from www.lumigent.com

> > Dinesh.



> > > Hi, All.

> > > It maybe a very simple stuff for all of you SQL gurus....anyhow, I am
> > trying
> > > to view a transaction log file (.LDF) for a database.  How can I view
> it?

> > > Thanx.

> > > SK



Sat, 29 May 2004 07:48:01 GMT
 Viewing a Log File
Sean,

The transaction log is used to support ROLLBACKs, either explicit or
implicit, and to enable recovery of the database in the event of a media
(disk) failure.

An implicit ROLLBACK can result from a multi-row INSERT, say a thousand row
INSERT, that on the last row violates a constraint such as a PRIMARY KEY
constraint. Because an INSERT is an atomic operation, either all of the
INSERT must succeed or all of the INSERT must fail. So even if only the last
row fails, SQL Server must ROLLBACK all the 999 adds prior to the one that
failed. The transaction log enables SQL Server to perform this ROLLBACK.

I'm assuming that you understand explicit ROLLBACKs and recovery procedures
in the event of disk failures.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:
> If no actual viewing, I am just wondering what the log file is for?  When
do
> we make a good use of it?

> SK



> > Sean,

> > From sqlserver side there isnt any provision for actual "viewing".
> > You can try lumigent explorer from www.lumigent.com

> > Dinesh.



> > > Hi, All.

> > > It maybe a very simple stuff for all of you SQL gurus....anyhow, I am
> > trying
> > > to view a transaction log file (.LDF) for a database.  How can I view
> it?

> > > Thanx.

> > > SK



Sat, 29 May 2004 11:24:00 GMT
 Viewing a Log File
It is generally a bad plan to go mucking about with log files.  There are some really good reasons that Microsoft made this tough to do.

If you really want to go rummaging through the log, there are a couple of choices.  Log explorer from Lumigent, Inc. would be my first recommendation.  If you want to "roll your own", first you need to have your head examined, then you need to get the appropriate version of Kalen Delaney's "Inside SQL Server" book for your version of SQL Server.

-PatP

========================================

Please post DDL at the very least, and DML when possible to make it easier for people to help you.

Please reply only via newsgroups, as I rarely reply to email.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 29 May 2004 12:38:52 GMT
 Viewing a Log File
If not, please read the SQL Server BOOKS ONLINE. It's is very well covered since it's the crux of SQL Server. Use Profiler,
triggers, constraints, etc to troubleshoot whatever problem you are trying solve
Keith
=================================================
*  This posting is provided "AS IS" with no warranties, and confers no rights.
*  Please do not send email directly to this alias.Respond to newsgroup

--------------------



|>Subject: Re: Viewing a Log File
|>Date: Mon, 10 Dec 2001 22:24:00 -0500
|>
|>Sean,
|>
|>The transaction log is used to support ROLLBACKs, either explicit or
|>implicit, and to enable recovery of the database in the event of a media
|>(disk) failure.
|>
|>An implicit ROLLBACK can result from a multi-row INSERT, say a thousand row
|>INSERT, that on the last row violates a constraint such as a PRIMARY KEY
|>constraint. Because an INSERT is an atomic operation, either all of the
|>INSERT must succeed or all of the INSERT must fail. So even if only the last
|>row fails, SQL Server must ROLLBACK all the 999 adds prior to the one that
|>failed. The transaction log enables SQL Server to perform this ROLLBACK.
|>
|>I'm assuming that you understand explicit ROLLBACKs and recovery procedures
|>in the event of disk failures.
|>
|>-------------------------------------------
|>BP Margolin
|>Please reply only to the newsgroups.
|>When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
|>can be cut and pasted into Query Analyzer is appreciated.
|>

|>> If no actual viewing, I am just wondering what the log file is for?  When
|>do
|>> we make a good use of it?
|>>
|>> SK
|>>
|>>


|>> > Sean,
|>> >
|>> > From sqlserver side there isnt any provision for actual "viewing".
|>> > You can try lumigent explorer from www.lumigent.com
|>> >
|>> > Dinesh.
|>> >


|>> > > Hi, All.
|>> > >
|>> > > It maybe a very simple stuff for all of you SQL gurus....anyhow, I am
|>> > trying
|>> > > to view a transaction log file (.LDF) for a database.  How can I view
|>> it?
|>> > >
|>> > > Thanx.
|>> > >
|>> > > SK
|>> > >
|>> > >
|>> > >
|>> >
|>> >
|>>
|>>
|>
|>
|>



Mon, 31 May 2004 15:55:02 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Viewing transaction log files

2. freeware product to view the log file

3. View sql log files

4. Viewing Transaction Log File

5. Viewing Transaction Log File

6. Tool to view a log file?

7. How can i view the Transaction Log file?

8. How to view the content of database's log file

9. Viewing contents of log file

10. Viewing log file ???

11. does DTS has log files to view history

12. How to view log file


 
Powered by phpBB® Forum Software