Petra Liljecrantz
Mar 21, 2016
(4 votes)

How to keep the integrity of a backup chain

This is the second post about issues I often encountered working for Episerver Managed Services. It´s not an Episerver specific blog post per se, but we often saw this problem and it has to do with developers messing up the integrity of a backup chain. For some people this might be obvious and a no brainer, but like I wrote, it was quite a big problem so people need to learn and be aware of this.

The backup chain

In any hosting environment, regardless if you have in-house hosting or with a hosting provider such as Episerver Managed Services there are of course backup jobs running to backup an SQL database. A common setup is to take a full backup once a week and differential backups running each day or perhaps a full backup once and then only differential backups each day. Regardless which approach is used it´s important to keep the integrity of the backup chain.

The issue

All too often partners or customers have access to the production database and performing backups before a deploy. That´s all good and is what should be done, but the developer might not have knowledge about how the backups are run and how a backup chain works, so when they do a backup they do a full backup and are not aware that by not checking the box Copy-only database they are destroying the backup chain causing the database not being able to be restored to the latest differential backup. In the case of trouble and the database have to be restored the previous differential backup can´t be used, it will mess up the database.

Of course the full backup done before the deploy was made could be used but then the backup chain has to be setup again with an initial full backup. And if the database backup in question has been deleted after the deploy or can´t be used for any other reason then a lot of data would be lost when having to revert back to the latest full backup in the backup chain.

The solution

Always check the Copy-only backup box when doing a backup before a deploy, as shown here:

Image copyonlycheck.png

Mar 21, 2016


Henrik Fransas
Henrik Fransas Mar 21, 2016 02:06 PM

This is very true and something non-dba are not aware of!

Arild Henrichsen
Arild Henrichsen Mar 21, 2016 03:21 PM

Good points. The problem you're highlighting here is a perfect example of shoot-from-the-hip devops. 

Whether the customer has Managed Services, a remote hosting partner, or hosts the servers inhouse - if you don't know what you're doing, stay the hell away from the databases. 

The developer is the very last person who should tamper with the DBs or the backup scheme - in 99% of cases that's someone else's job. 

I wrote a blog post about this kind of thing a few years back.. which hat is yours?

Petra Liljecrantz
Petra Liljecrantz Mar 21, 2016 03:30 PM

That was a funny post! I think I´m The Soldier :)

Henrik Fransas
Henrik Fransas Mar 21, 2016 04:49 PM

I am a cowboy....

K Khan
K Khan Mar 21, 2016 05:45 PM

any hat for Spartans?

Saif Mar 22, 2016 01:04 PM

Good point there, thanks Petra!

Please login to comment.
Latest blogs
Delete a content – the right way

I stumped upon this blogpost Delete content directly from the Optimizely database – Tomas Hensrud Gulla by Tomas, an OMVP. While the post is helpfu...

Quan Mai | Feb 8, 2023 | Syndicated blog

The Content Revolution - Generative AI

Hi Optimizely Community,  For the past two decades, you and Optimizely have been at the forefront of content management - creating, managing,...

Alex Atzberger | Feb 6, 2023

Delete content directly from the Optimizely database

Do you know your way around the Optimizely CMS database? Deleting, or updating, content directly in the database is pretty straightforward, but of...

Tomas Hensrud Gulla | Feb 6, 2023 | Syndicated blog

Rolling your site out to China

How to rollout your website to the China market Continue reading →

Andrew Markham | Feb 5, 2023 | Syndicated blog

Optimizely PIM - Variant Management Overhaul & Rollout

Optimizely PIM has completely overhauled variant management with improved usability and support for variant swatches. In order to enable this...

Arthur Vander Voort | Feb 4, 2023

You Just Got Vectored! SVG Image Formats

 If you're reading this, then you've come across a need that nearly all Opti developers encounter in their careers; You need to display a vector...

Greg J | Feb 3, 2023 | Syndicated blog