June 5, 2019 at 11:16 am
Hello everyone
Who has an idea how I can put a maintenace plan on a SQL Server RDS instance
so I had the information that the plan maintenance classic are not supported in RDS s
o who has a feedback experience on this topic
thank you
June 5, 2019 at 1:09 pm
what type of maintenance plan?
are you just looking for backups ? RDS handles most of this in the background, as it does with patching
you can't really backup a database to a file (easily) as RDS has no "visible storage"
Have a look at
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Maintenance.html
see where that takes you
for index defrag etc, you can use sql agent and script a defrag/reindex/update statistics set of jobs using TSQL code
https://aws.amazon.com/blogs/aws/amazon-rds-for-sql-server-supports-sql-server-agent/
you might find this resource usefull
the backup bits of the script won't help you, but there is a well regarded set of scripts for index management
MVDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply