Shulou(Shulou.com)05/31 Report--

This article will explain in detail what types of DBA backups are, Xiaobian thinks it is quite practical, so share it with you as a reference, I hope you can gain something after reading this article.

1 Why do you need backup? In everyday life, for example: program error, human error, computer failure, disk failure, unknown natural disaster (fire, earthquake) or theft,

All of this causes data loss.

2 What is backup? Backup is to establish a copy of data, used to restore and recover data after system failure, note: file copy ≠ backup

In daily life, for example: websites, schools, libraries, banks and many other places need to use the database, then, as a DBA engineer, daily must do is data backup.

First, we learn theoretical knowledge.

Backup type:

backup type description Full backup Backup of the entire database, partial transaction logs, database structure, and file structure, base of backup Differential backup Backup of all data changed since the last full backup, fast, and in less time Transaction log backup

The transaction log cannot be backed up until at least one full backup has been performed.

Transaction logs cannot be backed up in simple recovery mode

3. Without a database backup consistent with it, the transaction log cannot be restored.

Backup and restore strategies:

Policy Description Full Backup and Restore

Small databases, few databases The tables or read-only

Full + differential backups vs. restores Database changes frequently, minimal backup time is desired Full + transaction log backups vs. restores Database and transaction log backups combine, database changes frequently, full backups take too long Full + differential + transaction log backups vs. restores can reduce the number of transaction log backups required to restore, reducing the time to restore database

Recovery mode:

Recovery Mode Description Simple

Transaction logs cannot be used to restore data for small databases and databases that change infrequently

complete

1. All transactions are logged

Keep all logs until the transaction logs are backed up.

3. For production database

4. Support point-in-time restoration

Bulk log complete recovery mode supplement, only for the minimum record of bulk operations About "DBA backup types what" This article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.