How do I view transaction logs?

• Mar 24, 2003

• #2

Corran007

Programmer

May 20, 2002

530

US

You dont View. Microsoft provides no method to view them. There are some 3rd party tools that allow you to do so.

yes you should backup them up if your in production. if in development you can truncate them.

 

Upvote 0 Downvote

• Mar 24, 2003

• Thread starter
• #3

rushdib

Programmer

Jun 12, 2001

203

US

How do I truncate them?
I am starting up a replication for our database. One of our tables has two million records. After I create the publication. The snapshot agent tried to prepare the tables and it's failing in this particular table and I am getting the message the transaction log is full. How much space do I have to allocate for transaction logs?

Thank you,

Rushdi

 

Upvote 0 Downvote

• Mar 24, 2003

• #4

Corran007

Programmer

May 20, 2002

530

US

how much space is available on the server?

The transaction log usually gets full when it runs out of space on the server. As for space. Is the transaction log set to grow automaticlly or is it defined with a limit? if its defined, try allowing it to grow automaticlly.

 

Upvote 0 Downvote

• Mar 24, 2003

• #5

SemperFiDownUnda

Instructor

Aug 6, 2002

1,561

AU

Transaction logs normally are about 1/4th of the size of your database. Depending on your replication method and how often you replicate data this might have to be larger. If you are having problems replicating from a server because of space on thing to concider is to use another server as the distribution database.

 

Upvote 0 Downvote

• Mar 24, 2003

• #6

tlbroadbent

MIS

Mar 16, 2001

9,982

US

See faq183-1534 - Shrinking Databases and Logs - SQL 7 and Higher

You can view the transaction logs most easily with 3rd-party software. I use Lumigent's Log Explorer.

There is an undocumented DBCC command, DBCC LOG which can be used to view the transaction log. See the following link for a brief explanation.

http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm#part_2_8

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

Upvote 0 Downvote

• Mar 24, 2003

• #7

SemperFiDownUnda

Instructor

Aug 6, 2002

1,561

AU

oh also note that the transaction logs are "Held in an internal format" ie Microsoft reserves the right to change it willy nilly even on minor releases, patches and hot fixes.

 

Upvote 0 Downvote