Architecture

Open

Actions

1. Backup of the RDS database to S3 bucket

2. Mount the S3 bucket as a directory on the staging host

3. Mount Accelario disk to the staging server

4. Restore from the mounted directory to staging SQL Server instance (the instance is located on Accelario disk that was mounted in the previous action)

5. Create standard VDB

Prerequisites

1. RDS SQL Server instance

2. Staging EC2 Windows server with SQL Server instance up and running - same version as the RDS database

Preparations

1. Create a Standard S3 Bucket with a one folder inside.

2. Create IAM policy. It will be used for S3 bucket access from both RDS and EC2 servers.

3. Setup transaction log copy to s3, use the same bucket as point 1 above.
   
   

   exec msdb.dbo.rds_tlog_copy_setup @target_s3_arn='arn:aws:s3:::amzn-s3-demo-logging-bucket1/mynewfolder';

Source/Staging host config

1. Install s3fs on Staging Server.

2. Apply the IAM role to the server, so it will be able to read the S3 bucket.

3. Make sure that it has an SQL Server instance up and running - same version as the RDS database