Home Forums SQL Server 2005 Backups Create a policy to avoid backups withou copy_only option RE: Create a policy to avoid backups withou copy_only option

  • October 22, 2010 at 1:28 pm

    #1241149

    GilaMonster (10/22/2010)

    Correct. No full backup (with or without copy_only) breaks the log chain.

    Gail, I am confused here.

    For example, from FULL BAKCUP A to FULL BACKUP B, we have a log chain. If you issue a FULL backup C without COPY_ONLY between A and B, then, you break the previous log chain A to B.

    Right?

    According to Microsoft, you should backup log after the Full backup C to establish a new log chain.