question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

Does an ad hoc backup break my restore chain?

I was reading about copy-only backups, but I am confused. Does a normal, not copy-only backup break my log chain for restores?

backuprestorelog-backupdifferential-backup
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Tried to delete that answer. Can't.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

Yes and no. If by restore chain you're talking about a base backup and a set of log backups, no, it does not affect them. However, if you are talking about a base backup and a set of differential backups, then yes, it does completely interrupt the backup chain. Any new backup taken will cause the next differential to work from that new base, not the previous base. That's why copy only backups were introduced, to allow for a backup in the middle of the cycle that wouldn't reset the next differential.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.