Assumptions, assumptions, assumptions. These are the culprits that often cause a data backup and disaster recovery plan to fail. It’s too common to see cities still relying on consumer-grade solutions or manual data backups—and never testing them. Whether you use an online consumer-grade data backup solution, external hard drive, or even tape backup, don’t assume that your tool is backing up everything you need.
Unfortunately, when cities begin to restore their data after an incident or disaster, they can harshly learn that’s not the case. Certain kinds of critical data end up as not recoverable, and that puts cities in a bad situation. Permanent data loss may occur with records you are legally required to maintain, police records essential to investigations, or sensitive citizen data.
Here are four kinds of critical data that your data backup solution may not be backing up.
Databases are not like word processing files or PDFs. They are complex structured repositories of data that are built in layered, sophisticated ways. Because they may vary in size, that means they may also vary in the amount of time it takes to create a backup and the amount of storage space needed for the backup. Plus, databases are often frequently updated with a sequence of additions, deletions, and changes (transactions) keeping them in a state (open) that unsupported backup solutions or processes will fail to capture. In short, if what you are using or what you are doing to back up your database is not supported by the database vendor, then you are at great risk of not recovering your data when you need it.
We don’t want to get too technical in this post, but these are just a few questions that—even if the jargon is over your head—simply show that there is a lot to think about when backing up databases:
Specialized software and applications can become complex because sometimes the vendor desires to back it up in a proprietary way. However, if they aren’t responsible for backing up your software, then it’s up to you. So what do you do? How do you add an entire vendor’s software system to an external hard drive or a consumer-grade backup solution? Can you? If you can, will it even restore properly?
Backing up software and applications can get very technical, and incompatibility often exists between a vendor’s software and your data backup solution. Here are a few questions just to illustrate that you may have made some incorrect assumptions about backing up your software:
Many consumer-grade data backup solutions have trouble or lack the functionality to back up specific kinds of files. Others can back up those files but you may not realize that the default settings have missed backing up some of your most critical data.
Some examples of specific files that may not be getting backed up include:
Without knowing if you’re able to back up all files or not, you may overlook critical files needed to restore your systems.
We’re specifically highlighting email because so many cities still use consumer-grade online email as a “free” way to have email access for city employees. Also, it’s not uncommon to see personal email accounts used for city business. Whether it’s Gmail, Yahoo, AOL, or another provider, your emails are usually not backed up if something goes wrong. Additional red flags with these types of email accounts include adhering to city records retention policies and fulfilling Open Records Requests.
We’ve only scratched the surface of this topic here. But even if some of the discussion was technical, think primarily about the uncertainty it raises. Think about your payroll software, accounting software, financial databases, public safety data, court data, utility billing data, 911 systems, citywide email, and other mission critical systems. Is your current backup solution able to back all of these up? Or not?
Don’t wait to find out. Reach out to us today to talk about your data backup needs.
Original Date: 8/21/2019