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?
amazon-rdsamazon-web-services
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?
Best Answer
This is super easy to do if you follow the steps Importing and Exporting SQL Server Databases
Key steps being:
That script will return to you a task #. You can use the following script to track the progress:
Once you've done that then you can download the .bak file and restore locally (assuming same sql server versions running, etc)