Skip to content

Instantly share code, notes, and snippets.

@Verfranc

Verfranc/gist:06bb5016a3ddf1c4b5306839d5b656d9

Last active November 19, 2022 20:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Verfranc/06bb5016a3ddf1c4b5306839d5b656d9 to your computer and use it in GitHub Desktop.
Save Verfranc/06bb5016a3ddf1c4b5306839d5b656d9 to your computer and use it in GitHub Desktop.
Download ZIP
AWS RDS - MS SQL
Raw
gistfile1.txt
AWS Docs
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html#USER_ConnectToMicrosoftSQLServerInstance.Troubleshooting
https://docs.aws.amazon.com/vpc/latest/userguide/vpc-eips.html
AWS RDS SQL Server Database Restore using S3
https://www.youtube.com/watch?v=aj76RPamXeE
Amazon RDS - Common Issues with native SQL Server backup and restore
https://www.sqlmatters.com/Articles/Amazon%20RDS%20-%20Common%20Issues%20with%20native%20SQL%20Server%20backup%20and%20restore.aspx
SCRIPTS
exec msdb.dbo.rds_restore_database
@restore_db_name='companydb',
@s3_arn_to_restore_from='arn:aws:s3:::companytransfer/companydb.bak';
exec msdb.dbo.rds_task_status;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment