Getting Started with RDS for SQL Server Common Practices

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

**Table 1** Common practices
Practice		Description
Suggestions on using RDS for SQL Server	Instance Usage Suggestions	This practice provides suggestions on DB instance class, database connection, database migration, and instance usage.
SSRS deployment	Deploying SQL Server Reporting Services (SSRS) on RDS for SQL Server	This practice describes how to deploy SSRS on RDS for SQL Server.
Data migration	Migrating Data to RDS for SQL Server Using the Export and Import Functions of DAS	This practice describes how to use Data Admin Service (DAS) to export data from the source and then import the data to an RDS for SQL Server DB instance.
	Migrating Data from an ECS-Hosted SQL Server Database to RDS for SQL Server Using the Export and Import Functions of SSMS	This practice describes how to use SQL Server Management Studio (SSMS) to migrate data from an ECS-hosted SQL Server database to an RDS for SQL Server DB instance.
	Migrating Data from an On-Premises SQL Server Database to RDS for SQL Server Using the Export and Import Functions of SSMS	This practice describes how to use SSMS to migrate data from an on-premises SQL Server database to an RDS for SQL Server DB instance.
	Deploying SQL Server Reporting Services (SSRS) on RDS for SQL Server	This practice describes how to deploy SSRS on RDS for SQL Server.
	Migrating Backup Data of an RDS for SQL Server DB Instance to Another RDS for SQL Server DB Instance	This practice 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	This practice 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	This practice 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	This practice 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	This practice 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	This practice describes how to use DRS to synchronize data from SQL Server databases on other clouds to RDS for SQL Server.
Data backup	Intra-region automated backup	This practice 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.
Data backup	Intra-region manual backup	This practice 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	This practice 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.
Data restoration	Restoring a DB Instance to a Point in Time	This practice describes how to use an automated backup to restore instance data to a specified point in time.