How to solve transaction log error

• vijaysang123

  SSC Veteran

  Points: 277

  More actions

  July 1, 2002 at 3:47 am

  #158417

  What to do when i got this error "

  transaction log file is full backup your transaction log file and try again transaction"

  vijay verma

  
  vijay verma

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 1, 2002 at 4:08 am

  #431896

  Either do a transaction log backup or increase the size of your transaction log, or change it to truncate on checkpoint/simple mode.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter