x

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

avatar image

Steve Jones - Editor ♦♦
5.1k 79 93 87

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

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x235
x122
x19
x14

asked: Feb 19, 2010 at 01:53 PM

Seen: 3073 times

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

Copyright 2016 Redgate Software. Privacy Policy