I want to download one of my backups and restore it on my laptop for testing a web app locally. I'm using SQL Express.
This is similar to this MySQL question. Can I just run a backup using T-SQL? And then somehow direct it to S3?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
This is super easy to do if you follow the steps Importing and Exporting SQL Server Databases
Key steps being:
exec msdb.dbo.rds_backup_database @source_db_name='database_name', @s3_arn_to_backup_to='arn:aws:s3:::bucket_name/file_name_and_extension', @overwrite_S3_backup_file=1;
That script will return to you a task #. You can use the following script to track the progress:
exec msdb..rds_task_status @task_id= <your task #>
Once you've done that then you can download the .bak file and restore locally (assuming same sql server versions running, etc)