A Sql Database can be restored using .bak file
The below query can be used to restore database using a .bak file stored in AWS S3 bucket
exec msdb.dbo.rds_restore_database
-- replace name with the database name
@restore_db_name='<name>',
--Replace backup s3 path with the actual path.
--Eg. prod-backups/DLProdDB-12-07-19
--In this, prod-backups is the bucket name and DLProdDB-12-07-19 is the .bak --file name
@s3_arn_to_restore_from='arn:aws:s3:::{backup s3 path}'
To check the status of the restore, use the following query –
exec msdb.dbo.rds_task_status @db_name='<name>'
For more info, click here
