• 1) Included with the database backup and the all log backups that occur while it's running

    2) Included with the database backup and the all log backups that occur while it's running

    3) Included with the database backup and the all log backups that occur while it's running

    Full backups do not have any effect on the log backups that occur. The full backup backs up enough of the transaction log so that it can be restored consistently.

    A full backup does not mark where the next log backup should start from, a log backup always backs up from where the previous log backup finished up to current.

    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