Architect a disaster recovery for SQL Server on AWS: Part 1

 

New blog post - Architect a disaster recovery for SQL Server on AWS

 

Customers often ask for guidance on choosing the right HA or DR solution for SQL Server on AWS. 🤔

In this blog series, there is now a helpful and concise guide into various architectural best practices available. If you're looking for advice on trade-offs, operational costs & complexity, time to recovery... then this is it! 🔥

Topics include; backup and restore, SQL Server log shipping, SQL Server database mirroring, SQL Server Always on Failover Cluster Instances (FCIs), Always On availability groups, AWS Database Migration Service (AWS DMS) & CloudEndure Disaster Recovery.

📌 Links to bookmark: 📌

Part 1 - https://aws.amazon.com/blogs/database/part-1-architect-a-disaster-recovery-for-sql-server-on-aws/
Part 2 - https://aws.amazon.com/blogs/database/part-2-architect-a-disaster-recovery-for-sql-server-on-aws/
Part 3 - https://aws.amazon.com/blogs/database/part-3-architect-a-disaster-recovery-for-sql-server-on-aws/
Part 4 - https://aws.amazon.com/blogs/database/part-4-architect-a-disaster-recovery-for-sql-server-on-aws/

Now go build! 💥🚀

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

In this blog post, I covered how to simplify large SQL Server database migrations by leveraging AWS Snowball, AWS DataSync, and Amazon FSx. I demonstrated how you can optimize a one-time full backup transfer to AWS when there is a local network bandwidth constraint using an AWS Snowball device. I also showed how you can transfer incremental backups using AWS DataSync and Amazon FSx for Windows File Server, keeping your SQL Server in AWS up to date until your application cutover. This solution can help you automate and accelerate data transfer, freeing up your on-premises storage capacity. By doing so, you can reduce your organizational costs by moving that data off expensive storage systems.