Updated on 2025-11-11 GMT+08:00

RDS for SQL Server Common Tasks

After purchasing and connecting to a DB instance, you can view common tasks to better use RDS for SQL Server.

Table 1 Common tasks

Tasks

Description

Usage guidelines

Instance Guidelines

Provides guidelines on DB instance class, database connection, database migration, and instance usage.

Data migration

Migrating Backup Data of an RDS for SQL Server DB Instance to Another RDS for SQL Server DB Instance

Describes how to use DRS to migrate backup data from the source to an RDS for SQL Server DB instance.

From RDS for SQL Server to RDS for SQL Server

Describes how to use DRS to synchronize data from an RDS for SQL Server DB instance to another RDS for SQL Server DB instance.

Migrating Backup Data of an On-Premises SQL Server Database to an RDS for SQL Server DB Instance

Describes how to use DRS to migrate backup data of an on-premises SQL Server database to an RDS for SQL Server DB instance.

From On-Premises SQL Server to RDS for SQL Server

Describes how to use DRS to synchronize data from an on-premises SQL Server database to an RDS for SQL Server DB instance.

Migrating Backup Data of SQL Server Databases on Other Clouds to RDS for SQL Server

Describes how to use DRS to migrate backup data of SQL Server databases on other clouds to RDS for SQL Server.

From SQL Server on Other Clouds to RDS for SQL Server

Describes how to use DRS to synchronize data from SQL Server databases on other clouds to RDS for SQL Server.

Data backup

Same-Region Automated Backup

Describes how RDS for SQL Server automatically creates backups for a DB instance during a backup window and saves the backups based on the configured retention period.

Same-Region Manual Backup

Describes how to create manual backups for a DB instance. These backups can be used to restore data for improved reliability.

Data restoration

Restoring from Full Backups to RDS for SQL Server Instances

Describes how to use an automated or manual backup to restore a DB instance to how it was when the backup was created. The restoration is at the instance level.

Restoring a DB Instance to a Point in Time

Describes how to use an automated backup to restore instance data to a specified point in time.