Over a million developers have joined DZone.

The 3 Ts of Backups

DZone's Guide to

The 3 Ts of Backups

Backups are key to any business, but it isn't enough to just make a backup. Take a look at a simple process to help ensure your backup strategy is solid and simple.

· Database Zone ·
Free Resource

Find out how Database DevOps helps your team deliver value quicker while keeping your data safe and your organization compliant. Align DevOps for your applications with DevOps for your SQL Server databases to discover the advantages of true Database DevOps, brought to you in partnership with Redgate

I just read several more horror stories that include, among other things, failed backups. I’ve said it before (at volume, extreme volume), and evidently, I have to say it again. Simply creating a backup file is not enough to ensure the protection of your information. In order to attempt to reinforce the importance of this idea, I’m going to introduce a new concept. Maybe it’ll help. I’m calling it “The Three Ts of Backups.”

1. Take ‘Em

First, and most important, you have to Take backups. That’s your first “T.”

No, disk redundancy through RAID or a SAN or some other setup is not adequate to protect your information. You must take backups. They have to be created and they have to be run regularly. You absolutely should automate this.

2. Test ‘Em

Now that you are taking your backups, you need to Test your backups. That’s your second “T.”

Simply having a backup doesn’t mean much if you can’t restore it. How do you know if you can restore a backup? You test it. How do you test it? You run the restore process. Not only does this test your backup, but it tests your ability to do the restore. I would strongly recommend automating this as well.

 3. Transfer ‘Em

With your backups in place and tested, now you need to copy them to a second location. Transfer them offsite. This is your third “T.”

Things happen. Fire, flood, wind, and extra-solar radiation. Any, or all, of these things, and more, can affect your servers. So, let’s take our tested backups and transfer them to a second location (and maybe a third if we’re feeling really paranoid). One onsite and one in the cloud. One in a local data center and one in a distant data center. Oh, and let’s automate transferring the tested backups we’ve taken.

The 3 Ts


  1. Take ‘em.

  2. Test ‘em.

  3. Transfer ‘em.

Now get out there and make this happen. Take your backups. Test your backups. Transfer your backups. Automate each of these steps and validate that everything is actually working. It’s your information. It’s your business. If you want to protect it, you’ll do the Three Ts.

Align DevOps for your applications with DevOps for your SQL Server databases to increase speed of delivery and keep data safe. Discover true Database DevOps, brought to you in partnership with Redgate

database ,tutorial ,backups ,backup strategy

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}