October 19, 2017 at 1:10 pm
Hello DBA Gurus,
Can you suggest some technologies and Ideas for us to migrate our production DB servers to AWS.
Our scenario: We have about 8 critical Production DB Servers on SQL Server 2014 and Windows Server 2012. Each server has about 200 databases Total Size 3 TB.We need to create a DR in AWS.
I can do a backup restore , but need inputs on syncing the data with Primary source DBs. They are standalone instances . Can we try always on without clustering as clustering is out of the equation and so is 3rd party tools?
I cannot use log shipping , mirroring or replication and these are 1-1 AND we need some solution for 200 -200 databases. BUT , if we dont have any other option we may go with mirroring or log shipping.
Thanks in Advance.
October 19, 2017 at 2:04 pm
sqlguy80 - Thursday, October 19, 2017 1:10 PMHello DBA Gurus,Can you suggest some technologies and Ideas for us to migrate our production DB servers to AWS.
Our scenario: We have about 8 critical Production DB Servers on SQL Server 2014 and Windows Server 2012. Each server has about 200 databases Total Size 3 TB.We need to create a DR in AWS.
I can do a backup restore , but need inputs on syncing the data with Primary source DBs. They are standalone instances . Can we try always on without clustering as clustering is out of the equation and so is 3rd party tools?
I cannot use log shipping , mirroring or replication and these are 1-1 AND we need some solution for 200 -200 databases. BUT , if we dont have any other option we may go with mirroring or log shipping.Thanks in Advance.
There are several options depending on the maintenance window, transactional frequency etc. Start by having a look at http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
I've done this many times and every time there's a surprise 😉
😎
October 19, 2017 at 3:15 pm
Thank you Eirikur. I should have added , we don't use RDS but we will be using AMI's where I install SQL Server from scratch and will make a config file to automate the install.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply