On the DB manager (we’re using SQL Server Management Studio), connect to the DB and execute the following stored procedure:
exec msdb.dbo.rds_restore_database
@restore_db_name='PBDemoDB2022',
@s3_arn_to_restore_from='<ARN path of the bucket>/pbsqlserver.bak',
@with_norecovery=0,
@type='FULL';
You can obtain the bucket’s ARN path by opening the bucket and going to the Properties tab.
Wait a couple of minutes for the RESTORE operation to conclude.
After a couple of minutes you will be able to see the restored database on the Object Explorer:
