Migrate a multi-TB SQL Server database to Amazon RDS Custom for SQL Server using Amazon FSx for Windows File Server
Database Blog
The article provides a solution to migrate a multi-terabyte SQL Server database to Amazon RDS Custom for SQL Server when the total size, including backup files, exceeds 16 TB. It uses Amazon FSx for Windows File Server as staging storage.
Specifically, the article covers:
- Common challenges in migrating large databases to RDS Custom for SQL Server
- Solution overview using FSx File Gateway and FSx for Windows File Server
- Prerequisites for the solution
- Steps to back up the on-premises database to the FSx File Gateway file share
- Configuring Route 53 and joining the RDS Custom instance to an Active Directory
- Restoring the backup files on RDS Custom for SQL Server
- Clean-up steps to delete the FSx resources after migration
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Apr 11
2024
2024
Migrate Microsoft Azure SQL Database to Amazon RDS for SQL Server using Smart Bulk Copy
Apr 21
2025
2025
Migrate SQL Server user databases from Amazon EC2 to Amazon RDS Custom using Amazon EBS snapshots
Jan 3
2024
2024
Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator
Feb 19
2024
2024
Migrate tables from Microsoft Access to Amazon RDS for MySQL
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.