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.
Note
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.
Topics
- Accessing the tempdb database on Microsoft SQL Server DB instances on Amazon RDS
- Analyzing your database workload on an Amazon RDS for SQL Server DB instance with Database Engine Tuning Advisor
- Changing the db_owner to the rdsa account for your database
- Managing collations and and character sets for Microsoft SQL Server
- Creating a database user
- Determining a recovery model for your Microsoft SQL Server database
- Determining the last failover time
- Deny or allow viewing database names
- Disabling fast inserts during bulk loading
- Dropping a Microsoft SQL Server database
- Renaming a Microsoft SQL Server database in a Multi-AZ deployment
- Resetting the db_owner role membership for master user
- Restoring license-terminated DB instances
- Transitioning a Microsoft SQL Server database from OFFLINE to ONLINE
- Using change data capture
- Using SQL Server Agent
- Working with Microsoft SQL Server logs
- Working with trace and dump files
