Post reply

Whether the full backup includes log backup?

  • October 23, 2015 at 5:46 am

    #309226

    Hi,

    In SQL Server, whether the full backup of a database includes the backup of the log? Thanks

  • October 23, 2015 at 5:49 am

    #1835130

    Yes.

    It doesn't truncate the log, only log backups do that (in full/bulk-logged), but full backups do back up a portion of the log. If they didn't, it would not be possible to restore a database to a consistent state.

    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

  • October 23, 2015 at 9:37 am

    #1835233

    Just to clarify, a database backup does not fully back up the log. It gets only the active portion of the log necessary to bring that full backup to a usable state. Thus, one single full backup would not allow you to restore to different points in time. Full log backup is a completely separate task and process for SQL Server from database backup.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

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

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