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