Updated on 2024-09-12 GMT+08:00

RDS for SQL Server 2016

Category

Function Item

Version

Web Edition

Standard Edition

Enterprise Edition

Single

Single

Primary/Standby

Single

Primary/Standby

Instance management

Reboot an instance

Change the instance class

Reset a password

Change instance type from single to primary/standby

×

×

×

×

×

Scale up storage space

Manually switch between primary and standby instances

×

×

×

Delete a pay-per-use instance

Upgrade the DB engine version

×

×

×

×

×

Change the instance name

Change the instance description

Change the maintenance window

Tags

Manage tags

Task center

View a task

Data migration

Migrate backups using DRS

Database connection

Intra-VPC access

Public access

Change a floating IP address

Change a database port

Backup and restoration

Full backup (automated backup)

Incremental backup

Download a backup

Replicate a backup

Configure an automated backup policy

Restore data to RDS for SQL Server from backups

Restore an instance to a point in time

Manual backup

Restore data to a new instance

Restore data to an existing instance

Monitoring and alarms

Resource monitoring

DB engine monitoring

Set alarm rules

Parameter management

Create a parameter template

Compare parameter templates

Apply a parameter template

View application records of a parameter template

Modify parameters

Export a parameter template

View parameter change history

Log management

View and download system logs

View and download slow query logs

Security management

Cloud Trace Service (CTS)

Database Security Service (DBSS)

Server-side encryption

Change a security group

Configure the TDE function

×

×

×

Recycle bin

Modify the recycling policy

Rebuild an instance

DB engine functions

Account management

Database management

Microsoft Distributed Transaction Coordinator (MSDTC)

SQL Server Integration Services (SSIS)

×

FileStream

×

×

CLR integration

Create and configure Agent jobs and DBLinks

Stored procedures

Change a custom database name

Capture change data

×

Shrink a database

Replicate a database

Update database statistics

Trace flags

Best practices

Create a linked server