restore RDS database from S3

restoreDB.sql

-- Change [bucket] with your bucket name
exec msdb.dbo.rds_restore_database 
        @restore_db_name='Sitecore_Analytics', 
        @s3_arn_to_restore_from='arn:aws:s3:::[bucket]/Sitecore_Analytics.bak';


exec msdb.dbo.rds_restore_database 
        @restore_db_name='Sitecore_Core', 
        @s3_arn_to_restore_from='arn:aws:s3:::[bucket]/Sitecore_Core.bak';

exec msdb.dbo.rds_restore_database 
        @restore_db_name='Sitecore_Master', 
        @s3_arn_to_restore_from='arn:aws:s3:::[bucket]/Sitecore_Master.bak';

exec msdb.dbo.rds_restore_database 
        @restore_db_name='Sitecore_Web', 
        @s3_arn_to_restore_from='arn:aws:s3:::[bucket]/Sitecore_Web.bak';


exec msdb.dbo.rds_restore_database 
        @restore_db_name='Sitecore_Sessions',
        @s3_arn_to_restore_from='arn:aws:s3:::[bucket]/Sitecore_Sessions.bak';
 
 
-- Check status of restore operation
exec msdb.dbo.rds_task_status @db_name='Sitecore_Core'
exec msdb.dbo.rds_task_status @db_name='Sitecore_Master'
exec msdb.dbo.rds_task_status @db_name='Sitecore_Web'
exec msdb.dbo.rds_task_status @db_name='Sitecore_Analytics'
exec msdb.dbo.rds_task_status @db_name='Sitecore_Sessions'