/
Prepare to work with AWS RDS SQL Server

Prepare to work with AWS RDS SQL Server

Architecture

 

AWS RDS MSSQL architecture.drawio-20241105-081133.png

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

 

Related content

Prepare to work with AWS RDS Oracle
Prepare to work with AWS RDS Oracle
More like this
New Features and Enhancements 21.0
New Features and Enhancements 21.0
More like this
Accelario AWS RDS Virtualization Cost Calculator
Accelario AWS RDS Virtualization Cost Calculator
More like this
Release Notes - Data Virtualization Platform V23.0
Release Notes - Data Virtualization Platform V23.0
More like this