Problems with backup

• john_s50

  SSC Veteran

  Points: 213

  More actions

  May 3, 2006 at 9:05 am

  #168762

  When I do a full database backup in sql 2005, it does not truncate the transaction log like it does in sql 2000.

  Is it supposed to be that way? (if so, can you point me to documentation on it?)

  Is there something wrong with my installation?

  Can anyone confirm that it works that way?

  Thanks for your help.

  John

• peterhe

  SSChampion

  Points: 11469

  More actions

  May 4, 2006 at 6:49 am

  #635904

  I don't think SQL server 2000 truncates the transaction log after a full backup. You need to run BACKUP LOG command explicitly both in 2000 and 2005 to truncate tran log. I didn't see any changes in the behaviour here.

   

• Todd Stu

  Say Hey Kid

  Points: 690

  More actions

  May 4, 2006 at 11:02 am

  #636041

  either add transaction log backups to the maintenance plan or change the db to simple.

  if log has grown, probably shrink it after the data used decreases.

  ---

  Cheers,

  Todd
  

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 4, 2006 at 10:12 pm

  #636139

  I agree with the above comments.  A full database backup does not truncate the transaction.  Enough of the transaction log is backed up so as to create a stable backup for restoration.  You will find this info in BOL.

  Lynn