Post reply

Truncating Log During Backup

  • May 8, 2008 at 6:21 am

    #123723

    I don't think the following actually truncates the log... but can someone verify if it does or doesn't?

    BACKUP DATABASE [databasename] TO DISK = N'D:\Backup Files\DATABASENAME.BAK' WITH INIT , NOUNLOAD , NAME = N'databasename backup', SKIP , STATS = 10, NOFORMAT

    Thanks.

    RAA

  • May 8, 2008 at 6:41 am

    #812374

    Database backups do not truncate the trasnaction log. They back up enough of the log to ensure that the backup is consistent when restored.

    Only a transaction log backup truncated the transaction log (in full and bulk-logged recovery modes)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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