The blog was written by Buda Consulting, a Dbvisit Gold Partner that provides database design, application development and database administration. The original blog can be found on the Buda Consulting blog.
With cybercrime still on the rise, and remote work scenarios stressing IT infrastructures and security controls, every organization needs a disaster recovery (DR) plan to protect against data loss and quickly restore IT infrastructure and systems following a significant outage.
But planning for Disaster Recovery (DR) is only the first step. You might think your plan is solid, but you need to test it regularly and keep it updated as your environment constantly changes. Otherwise, you will uncover its shortcomings at the worst possible time—in the midst of a disaster.
Yet according to a recent survey, only about half of SMBs have a documented, company-wide DR plan in place. Of that subset, 50% test their DR plan annually or even less frequently, while 7% have never performed any DR testing.
Shockingly, not a single survey respondent said their last DR test was even moderately successful—every company in the survey that conducted testing reported experiencing significant issues impacting the network, service availability and performance, data integrity, and/or critical workloads. But at least these firms know what they need to fix.
Insurance can blunt the financial impacts of a disaster, but lost data may be irreplaceable. Unless you have a DR plan and test it regularly, chances are almost 80% that your business will experience significant downtime, data loss, and other negative impacts within a few years.
3. Reputational damage. Chances are you’ve worked long and hard to build a reputation as a reliable partner. But you can lose that in minutes, and the cost while hard to quantify will be enormous. Your failure to invest in protecting your business is not something that will impress customers or prospects. Without DR testing your priceless business reputation is not safe.
4. Cybersecurity risk. When an organization is trying to recover from a disaster, some of its cybersecurity controls may be rendered ineffective, increasing the risk of an attack. Conversely, conducting DR testing helps you identify and remediate critical vulnerabilities before hackers have a chance to exploit them.
In short, unless you can afford to lose revenue, customers, and your good name in the market, DR testing is mission-critical.
The purpose of DR testing is to gauge the effectiveness of your DR plan and determine whether you can restore operations within the planned timeframe (your Recovery Time Objective or RTO). DR testing will also reveal faults in your IT and/or database environment that you need to fix.
Of course, DR testing also tests and trains your key employees who have responsibilities for restoring your business. The more they can practice the better they will perform when a real disaster is declared.
DR testing doesn’t have to be a full-on simulation scenario where systems go down. You can learn a lot by reviewing your DR plan in a tabletop exercise. Think of it as a dress rehearsal, a step-by-step walk-through of the plan. It’s a great way to spot problems, especially missing pieces and errors.
How often should you perform DR testing? At least once every six months, given the pace of change in the average IT environment and the importance of practice for human performance.
In today’s business environments, continuous availability is the target as downtime for mission-critical applications—like your databases—is considered unacceptable. Getting to “zero downtime” for your database environment, even in the face of outages and interruptions, usually requires special expertise and services to maximize the benefits of the high availability and DR capabilities your Oracle, Microsoft or other RDBMS offers.
You can contact Buda Consulting to discuss a Reliability Review, their proven and tested approach that will evaluate your current risk profile and help determine the level of protection your database environment requires.