TechTarget.com/searchdatabackup

https://www.techtarget.com/searchdatabackup/tutorial/Backup-testing-A-step-by-step-tutorial

Backup testing: A step-by-step tutorial

By Nick Cavalancia

Backups without testing are potentially worthless. Harsh, I know, but when you consider the importance of the data, applications, systems and workloads those backups contain, if you never test them, you run the risk of recovery failure.

It's necessary to have some kind of testing plan in place to ensure your backups will actually do what you believe they will should a restore scenario occur. In this article, I'll break down backup testing into three basic steps you can follow, providing options along the way to meet specific testing needs.

Step 1: Determine which backups require testing

You might be thinking every backup set requires testing, but that's not always feasible. Testing every single backup created would pretty much be the same as performing an enterprise-wide recovery. Instead, prioritize those backups that are so critical you want to ensure a successful recovery of that same data set.

Here are some ways you can approach determining which backups should be tested:

Step 2: Determine how you will test backups

In general, there are different kinds of backup testing that organizations use to validate their backups. Depending on your staffing, expertise and comfort level, either way of testing is better than doing no testing at all. The goal is to simply validate the data integrity of the backup created. This is accomplished using products offering the ability to verify backups. Possible testing aspects include:

Step 3: Determine backup testing frequency

Once you've bought into the need to test backups, this gets either really easy or moderately difficult -- all depending on whether you can automate testing with your backup product. Putting that aside for a moment, let's discuss how you establish the answer to the question of, "How often should I test?"

The simple method is to look at the criticality of the system, application or workload and, based on how important it is to ensure the ability to restore its backup, determine a testing schedule.

Here are my recommendations regarding the frequency of backup testing:

06 Sep 2019

All Rights Reserved, Copyright 2008 - 2025, TechTarget | Read our Privacy Statement