AWS RDS SQL server Instance database move to On -premise SQL server

Question

Hi All, I know this is an SQL server forum,still let me know your thoughts and same posted in AWS forum too..awaiting an response. Issue, there is an application which is related to SQL server database with 4TB database..due to some issues... we need to migrate that database from AWS RDS instance to On premise sql server alwayson..hence would like to know. what and all need to consider - 1.inorder to move RDS database to on premise server. 2.what method we need to use move that database(4TB) to on premise SQL server. Please help and assist on this,your help much appreciated.

Answer 1

I don't know much about RDS, but as I understand it is just SQL Server. It's not like Azure SQL Database, something special. This means that you could just take a backup of the database (WITH COMPRESSION!) and download and restore it. Although that presumes that Amazon let's you take backups. And that you can access the backup.

Now, I am here thinking that you can take down the application for the entire period, and I will not be surprised if you tell me that this is out of the question. If take full backups combined with COPY_ONLY log backups, you may be able to cut down the downtime.

Answer 2

Hi @S_NO ,

Please refer to this link:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

Best regards,

Seeya