Following, you can find a list of the Amazon RDS functions and stored procedures that help automate SQL Server tasks.
| Task type | Procedure or function | Where it's used |
|---|---|---|
| Administrative tasks |
|
Dropping a database in an Amazon RDS for Microsoft SQL Server DB instance |
|
|
Determining the last failover time for Amazon RDS for SQL Server | |
rds_manage_view_db_permission |
Deny or allow viewing database names for Amazon RDS for SQL Server | |
|
|
Renaming a Amazon RDS for Microsoft SQL Server database in a Multi-AZ deployment | |
|
|
Viewing error and agent logs | |
|
|
This operation is used to set various DB instance configurations: |
|
|
|
Transitioning a Amazon RDS for SQL Server database from OFFLINE to ONLINE | |
|
|
Turning on SQL Server Agent job replication | |
|
|
To see the values that are set using
|
|
|
|
Shrinking the tempdb database | |
| Change data capture (CDC) |
|
Disabling CDC |
|
|
Enabling CDC | |
| Database Mail |
|
Viewing messages, logs, and attachments |
|
|
Viewing messages, logs, and attachments | |
|
|
Viewing messages, logs, and attachments | |
|
|
This operation is used in starting and stopping the mail queue: |
|
|
|
Deleting messages | |
| Native backup and restore |
|
Backing up a database |
|
|
Canceling a task | |
|
|
Finishing a database restore | |
|
|
Restoring a database | |
|
|
Restoring a log | |
| Amazon S3 file transfer |
|
Deleting files on the RDS DB instance |
|
|
Downloading files from an Amazon S3 bucket to a SQL Server DB instance | |
|
|
Listing files on the RDS DB instance | |
|
|
Uploading files from a SQL Server DB instance to an Amazon S3 bucket | |
| Microsoft Distributed Transaction Coordinator (MSDTC) |
|
Using transaction tracing |
| SQL Server Audit |
|
Viewing audit logs |
| Transparent Data Encryption |
|
Support for Transparent Data Encryption in SQL Server |
| Microsoft Business Intelligence (MSBI) |
|
This operation is used with SQL Server Analysis Services (SSAS): This operation is also used with SQL Server Integration Services (SSIS): This operation is also used with SQL Server Reporting Services (SSRS): |
|
|
This operation shows the status of MSBI tasks: |
|
| SSIS |
|
Dropping the SSISDB database |
|
|
Creating an SSIS proxy | |
| SSRS |
|
Deleting the SSRS databases |
