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

  • 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?

    No. You can make as many full backups as you want between full backup A and B, and you will not break the log chain.

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

    Could you please provide the URL to the article? I would like to see the context the recommendation was made in.

    Thanks.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.