The Curious Case of… the failing differential restore


(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some testing, or were asked in a random question from the community.)

First blog post of the year!

This is an issue that’s come up several times over the last few weeks: restore of a differential backup failing while initializing a log shipping secondary.

In one case, the database is over a terabyte and has a lot of changes being