Common DBA Tasks for Microsoft SQL Server
This section describes the Amazon RDS-specific implementations of some common DBA tasks for DB instances that are running the Microsoft SQL Server database engine. In order to deliver a managed service experience, Amazon RDS does not provide shell access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges.
When working with a SQL Server DB instance, you can run scripts to modify a newly created database, but you cannot modify the [model] database, the database used as the model for new databases.
- Accessing the tempdb Database on Microsoft SQL Server DB Instances on Amazon RDS
- Analyzing Your Database Workload on an Amazon RDS DB Instance with SQL Server Tuning Advisor
- Collations and Character Sets for Microsoft SQL Server
- Determining a Recovery Model for Your Microsoft SQL Server Database
- Dropping a Microsoft SQL Server Database in a Multi-AZ with Mirroring Deployment
- Renaming a Microsoft SQL Server Database in a Multi-AZ with Mirroring Deployment
- Resetting the db_owner Role Password
- Restoring License-Terminated DB Instances
- Transitioning a Microsoft SQL Server Database from OFFLINE to ONLINE
- Using SQL Server Agent
- Working with Microsoft SQL Server Logs
- Working with Trace and Dump Files
- Related Topics