Easy to master the way of database management--operation and maintenance patrol four (database backup)

Objective

To do daily inspection is an important step of database management and maintenance, and it is necessary to register each inspection date and result, and may need to make a inspection report.

This series is designed to address some common problems:

• I don't know what to patrol.
• Don't know how to get a quick checkup
• Machine Too much physical examination trouble
• Difficult to generate reports, no visual rendering of results

Daily backup is the basic work of operation and maintenance personnel, ensure the backup strategy is perfect, backup can be the most heavy of operation and maintenance personnel.

Overview check

The backup check is a large item in the SQL Expert cloud check, as well as the importance of the backup, which is checked against the backup policy in the "Check items"-"Backup" page, and a warning is given when the policy is unreasonable.

　　

More information

On the database-backup page, you can view the details of the backup, including the time information for the backup, the path and backup file size, the LSN number, and so on.

Note: Currently only checks the backup of the database itself, some third-party software backup information may be missing.

Note: The considerations for Backup and the best configuration are described in backing up related articles on the platform.

　　

Summarize

Backups are a central priority in database maintenance and can be restored by backup when the server fails or the Misoperation results in data loss. The more complete the database backup, the more data you can restore back after a failure.

Suggestions:

• 1. Data loss tolerance is small, it is recommended to use the full recovery model, daily full backup, hourly (custom) log backup.
• 2. Backup uses a compressed backup method to reduce disk space consumption.
• 3. backup files and data files do not put on the same physical disk, if a disk failure can cause data and backup corruption or loss.
• 4. For disaster tolerance, it is recommended to add an offsite backup strategy.

　　

　　

Easy to master the way of database management--operation and maintenance patrol four (database backup)