Setting up AWS RDS MSSQL instance from .bak file
I am trying to set up a MSSQL database on Amazon’s RDS system. I have an instance of the database as a .bak file on S3 (and a local filesystem). I can’t figure out how to populate the database with this .bak file. Is there an easy to access tool?
2 Solutions collect form web for “Setting up AWS RDS MSSQL instance from .bak file”
Amazon RDS for SQL Server does not allow you to import data via a backup file.
Your choices are:
- Generate and Publish Scripts Wizard
- Import and Export Wizard
- Bulk copy feature
The Amazon RDS Users Guide has good explanations of how to do this with all three choices. See here.
AWS now supports MS SQL data restoring from a bak in S3. Attached a link with all the steps needed:
Also this is the official AWS documentation: