Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I view transaction logs?

Status
Not open for further replies.

rushdib

Programmer
Jun 12, 2001
203
US
Hi,
How do I view transaction logs from enterprise manager? Do I have to back up transaction logs to free up space?
 
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.
 
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
 
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.
 
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.
 
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.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top