2

Trying to mirror an on-premise SQL Server instance to EC2 instance, but not much information is available on this topic. The closest one I managed to find is: Implement SQL Server High Availability and Disaster Recovery on Amazon EC2 - Part 4

Has any one done this? If so is there any documentation available?

My intention is to make the EC2 as a backup for the HA in case my on-premise DB crashes.

Please note that this is not for AWS RDS, nor EC2 SQL Server to EC2 SQL Server; but on-premise SQL Server to AWS EC2 SQL Server.

The DB version is not a constraint, it can be SQL Server 2017 too.

asked Jul 31, 2018 at 20:52

1 Answer 1

0

I know this is very old but yes I have this working. Ended up using mirroring due to company policy between SQL 2016 AWS and on premise SQL 2016 running on Vmware.

Found this link very helpful.

https://tecadmin.net/setup-database-mirroring-sql-server/

I know not exactly what you were looking for but thought might help.

answered Sep 12, 2019 at 5:55

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.