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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

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

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