Help Center/ Relational Database Service/ User Guide (Ally Region)/ Working with RDS for SQL Server/ Data Backups/ Introduction to Backups
Updated on 2026-04-24 GMT+08:00
View PDF
Share

Introduction to Backups

What Are Database Backups

RDS for SQL Server automatically creates backups for DB instances during the backup time window. The backups are stored based on a preset retention period (1 to 732 days).

A backup is generated each time a backup is complete. If the instance fails or data is damaged, you can use the backup to restore the instance, ensuring data availability.

Backup Types

RDS for SQL Server supports multiple backup types. For details, see Backup Types.

Where Data Is Backed Up

  • Single-node instance

    It uses a standalone architecture, which is more cost-effective than mainstream primary/standby instances. After a backup is triggered, data is backed up from the primary instance and automatically stored as a package in OBS buckets. The backup does not take up storage space of your instance.

  • Primary/standby instance

    It uses an HA architecture. In a primary/standby pair, each instance has the same instance class. After a backup is triggered, data is backed up from the standby instance (or from the primary instance only when there is a long primary/standby replication delay) and automatically stored as a package on OBS buckets. The backup does not take up storage space of your instance.

    If a database or table in the primary instance is maliciously or mistakenly deleted, the database or table in the standby instance will also be deleted. In this case, you can only use backups to restore the deleted data.

How Data Is Backed Up

RDS for SQL Server automated backup is enabled by default and cannot be disabled. RDS for SQL Server performs automated full backups based on the time window and cycle specified in the backup policy. It also backs up data changes made after the most recent automated full or incremental backup every 5 minutes. When you restore an instance to a point in time, the most recent full backup will be downloaded from OBS for restoration. After the restoration is complete, incremental backups will be replayed to the specified point in time.

Figure 1 How data is backed up

Backup Solutions

Table 1 describes how to back up data and download backups.

Table 1 Backup solutions

Task

Backup Type

Description

Backing up data in the same region

Automated backups

RDS automatically creates full backups for your instance during a backup window you specified and saves the backups based on the configured retention period. If necessary, you can restore data to any point in time within the backup retention period.

Once the automated backup policy is enabled, a full physical backup is triggered immediately. After that, full backups will be created according to the specified time window and backup cycle.

Manual backups

Manual backups are user-initiated full backups of instances. The backup method is physical backup. Manual backups will not be deleted until you delete them manually.

Incremental backups

Transaction logging is enabled for RDS for SQL Server instances by default. RDS automatically backs up data modifications made after the most recent automated or incremental backup every five minutes.

Downloading backups

Downloading a backup

You can use OBS Browser+, the browser, or the download URL to download a backup.

Deleting Backups

Manual backups and automated backups can be deleted in different ways:
  • Manual backups can only be manually deleted.
  • Automated backups cannot be manually deleted. To delete them, you can adjust the retention period specified in your automated backup policy. Retained backups will be automatically deleted at the end of the retention period.
Parent topic: Data Backups