I have a question for you folks who might be familiar with the intricacies of restoring a .bak file from S3 to an AWS RDS MS SQL instance. Here is what I have tried, and how far I have gotten:
First some context: I am the sole IT guy at an all Mac, non-profit, special needs school (we help the kids who fall through the cracks). I recently received a backup of our SIS from a vendor who could only provide it by way of an MS SQL backup file, which ends in .bak. According to my research, I should be able to spin up a free AWS RDS instance of MS SQL, and then restore the .bak file to that free instance.
I have successfully created an AWS account with a free-tier RDS instance that has a singular, blank (brand new) MS SQL database called database-1. The instance is using MS SQL Express, version 14 (as far as I can tell). Other specific actions I have taken include the following, all taken from articles I have found online discussing how to do this:
Created an Option Group with the MSSQK-BACKUP-RESTORE option, and added that Option Group to the RDS database called database-1.
Created an IAM role called restoreadmin and gave it premissions to do everything on my S3 instance.
Created an S3 bucket called Achieve-DB, and uploaded the MS SQL backup file to it.
The articles I used to guide me through all of this, btw, are:
- Amazon RDS Support for Native Backup and Restore in SQL Server
- Secure Access to S3 Buckets Using IAM Roles
However, despite doing everything listed above, including banging my head on the keyboard a few times, I am not able to restore the backup from S3 to the database in RDS. The procedure for doing so, ostensibly, is the following:
- Within the RDS console, select the database you would like to restore to,
- Click the Restore from S3 button
- Follow the wizard...
The problem I am running into is that when I click on the Restore from S3 button, the only two options for restoring are Amazon Aurora and MySQL.
Can anyone here suggest where I might be going wrong? Thank you!!