• sqlguy80 - Thursday, October 19, 2017 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.

    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 😉
    😎