Best Practices

This chapter describes best practices for working with RDS for SQL Server and provides operational guidelines that you can follow when using this service.

**Table 1** RDS for SQL Server Best Practices
Reference	Description
Restoring Data from Backup Files to RDS for SQL Server DB Instances	Describes the version restrictions on RDS for SQL Server backup and restoration.
Migrating Data from a Self-Managed SQL Server Database on an ECS to an RDS for SQL Server DB Instance	Describes how to migrate a self-managed SQL Server database on an ECS to an RDS for SQL Server DB instance.
Modifying Parameters of RDS for SQL Server Instances	Describes how to modify parameter templates of RDS for SQL Server DB instances.
Supporting DMVs	Describes how to dynamically manage views through DMV on RDS for SQL Server.
Using the Import and Export Function to Migrate Data from a Local Database to an RDS for SQL Server DB Instance	Describes how to migrate an on-premises SQL Server database to an RDS for SQL Server DB instance.
Creating a Subaccount of rdsuser	Describes the permissions of the rdsuser account and how to create and manage IAM users under the rdsuser account.
Creating tempdb Files	Describes how to create tempdb temporary data files on RDS for SQL Server.
Microsoft SQL Server Publication and Subscription	Describes how RDS for SQL Server provides the subscription function.
Installing a C# CLR Assembly in RDS for SQL Server	Describes how to add a c#CLR assembly on RDS for SQL Server.
Creating a Linked Server for an RDS for SQL Server DB Instance	Describes how to create a linked server to access another RDS for SQL Server DB instance.
Deploying SQL Server Reporting Services (SSRS) on RDS for SQL Server	Describes how to deploy SQL Server Reporting Services (SSRS) in RDS for SQL Server.
Shrinking an RDS for SQL Server Database	Describes how to use a stored procedure to shrink the size of the data and log files in a specified RDS for SQL Server database.
Using DAS to Create and Configure Agent Job and DBLink on the Master and Slave Databases for RDS for SQL Server Instances	Describes how to use DAS to create and configure agent jobs and DBLink on primary and standby RDS for SQL Server DB instances.
Creating a Job for Scheduled Instance Maintenance	Describes how to create a scheduled SQL agent job to re-create indexes, update statistics, and shrink the database.
Security Best Practices	Provides guidance on RDS for SQL Server security configurations.