Transaction log

• mupparaju78

  SSChasing Mays

  Points: 646

  More actions

  April 22, 2010 at 1:54 am

  #142661

  what is use of transaction log and how many logs is there in sql server 2005. plz let me know clearly. can u send any docs . thats very usefull for me.

  thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 22, 2010 at 2:17 am

  #1155905

  Read this:

  http://www.sqlservercentral.com/articles/64582/

  -- Gianluca Sartori

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  April 22, 2010 at 6:07 am

  #1156012

  How many databases do you have? That's how many transaction logs you have.

  That article is a good introduction.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning