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?

more ▼

asked Feb 19, 2010 at 01:53 PM in Default

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 78 79 82

Tried to delete that answer. Can't.
Feb 19, 2010 at 05:17 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Feb 19, 2010 at 03:39 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 19, 2010 at 01:53 PM

Seen: 2681 times

Last Updated: Feb 19, 2010 at 03:40 PM