0

New to cloud and have questions on AWS RDS SQL Server Instance, Question in Maintenance Plan.

As a DBA team we are expecting RDS access and admin access on SQL box. But was limited with setupadmin and process admin. Not able to see the error log even.

I don't even see the maintenance plan under management.

Questions:

  1. Why limiting access? since we are not the DBAs for these servers?

  2. Do we need to set up regular backups(full, log) for the user databases of AWS will be taking care of it?

  3. How about the user database maintenance like index maintenance and update stats?

Thank you in advance !

3

Why limiting access? since we are not the DBAs for these servers?

Amazon RDS is a Platform-as-a-Service offering, meaning the vendor is taking care of the infrastructure and platform setup, deployment and management. In order to secure and stabilise the managed platform, you're restricted in what access you have.

You do not have higher privileged access because A) you do not require it, higher privilege tasks are handled by the vendor, and B) it would represent a security and/or stability risk for the vendor to expose these higher privileges to you.

Do we need to set up regular backups(full, log) for the user databases of AWS will be taking care of it?

AWS RDS for SQL Server features automatic backups by default. See the FAQ section Backup and Restore. By default, backups are only retained for 7 days, however, your AWS admins can increase this to align with your organisations data retention policies.

How about the user database maintenance like index maintenance and update stats?

Optimisation tasks like Index Maintenance will not be taken care of by the vendor, however, AWS RDS does allow you access to deploy SQL Server Agent jobs. You could deploy Ola Hallengren's T-SQL based SQL Server Maintenance Solution and schedule it via Agent jobs to handle index & statistics maintenance.

Here is a link to AWS documentation for some common SQL Server DBA tasks in AWS RDS.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.