Post reply

Problems with backup

  • 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

  • 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.

     

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply