Help Center> Relational Database Service> User Guide> Working with RDS for SQL Server> Backups and Restorations> Working with Backups
View PDF

Working with Backups

RDS supports DB instance backups and restorations to ensure data reliability.

RDS uses Sysbench to import data models and a certain amount of data. After data is backed up, the compression ratio is about 80%. The more duplicate data is, the higher the compression rate is.

Compression ratio = Space occupied by backup files/Space occupied by data files x 100%

Functions

Although RDS supports high availability, if a database or table is maliciously or mistakenly deleted, data on the standby DB instance is also deleted. In this case, backups can be used to restore DB instances after data is deleted.

Automated Backups

Automated backups are created during the backup period of your DB instances. RDS saves automated backups based on the retention period you specified. If necessary, you can restore to any point in time during your backup retention period.

Manual Backups

Manual backups are user-initiated full backups of DB instances. They are retained until you delete them manually.

Full Backups

The full backup mode is used to back up all target data even if no data is updated since the last backup.

Incremental Backups

Incremental backups refer to transaction log backups. RDS automatically backs up the data updated since the last automated or incremental backup every five minutes.

Parent topic: Backups and Restorations