Skip to main content
changed link to docs
Source Link
Sean Gallardy
  • 39.3k
  • 3
  • 49
  • 92

Besides being unaware that your backup is being performed as a COPY_ONLY backup instead of not being backed up at all, are there any caveats that anyone can think of if this switch is set to default Y or even if it's used at all?

A COPY_ONLY full backup is still a full backup. The only difference between the two is the COPY_ONLY will not reset certain tracking bitmaps. This means your differential backups will eventually be the size of your database.

https://technet.microsoft.com/en-us/library/ms191495(v=sql.110).aspxhttps://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/copy-only-backups-sql-server

Besides being unaware that your backup is being performed as a COPY_ONLY backup instead of not being backed up at all, are there any caveats that anyone can think of if this switch is set to default Y or even if it's used at all?

A COPY_ONLY full backup is still a full backup. The only difference between the two is the COPY_ONLY will not reset certain tracking bitmaps. This means your differential backups will eventually be the size of your database.

https://technet.microsoft.com/en-us/library/ms191495(v=sql.110).aspx

Besides being unaware that your backup is being performed as a COPY_ONLY backup instead of not being backed up at all, are there any caveats that anyone can think of if this switch is set to default Y or even if it's used at all?

A COPY_ONLY full backup is still a full backup. The only difference between the two is the COPY_ONLY will not reset certain tracking bitmaps. This means your differential backups will eventually be the size of your database.

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/copy-only-backups-sql-server

Source Link
Sean Gallardy
  • 39.3k
  • 3
  • 49
  • 92

Besides being unaware that your backup is being performed as a COPY_ONLY backup instead of not being backed up at all, are there any caveats that anyone can think of if this switch is set to default Y or even if it's used at all?

A COPY_ONLY full backup is still a full backup. The only difference between the two is the COPY_ONLY will not reset certain tracking bitmaps. This means your differential backups will eventually be the size of your database.

https://technet.microsoft.com/en-us/library/ms191495(v=sql.110).aspx