Backup for databases: Get familiar with the type you use

The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit.

In order to back up a database, you need to know how it’s delivered, but you also need to know which of the more than 13 types of database designs it employs. Here we’ll cover four of them—relational, key-value, document, and wide column—that generate a lot of backup questions.

Understanding these models will help the backup team create a relationship and trust level with the database admins, and that will help both parties.

Four database types

Relational

A relational-database management system (RDBMS) is a series of tables with a defined schema, or layout, with records in rows of one or more attributes, or values.  There are relationships between the tables, which is why it is called a relational database, and why backups generally have to back up and restore everything. Examples of RDMBSs include Oracle, SQL Server, DB2, MySQL, and PostgreSQL

To continue reading this article register now