Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Friday, April 24, 2020 10:26 PM
Our on prem SQL 2014 instance with standard license doesn't have Always on Availability groups. We don't want to spend the money to upgrade to an enterprise license or get more servers and another SAN for a geo cluster or other HA solution.
I'm looking at AWS RDS services with a standard license, has anyone used this successfully with log shipping? What have been your costs and experiences?
Sunday, April 26, 2020 12:48 AM
Do you want to build log shipping between on-prem SQL Server 2014 and AWS RDS?
If you can make sure the on-prem server and AWS RDS service can communicate with each other, maybe it is possible.
Monday, April 27, 2020 3:22 AM
Hi techieplaya,
I have not this experience, so I can only search some information about this for you.
Please refrence whether this is helpful: sql-server-log-shipping-within-the-aws-cloud-2
Best Regards.
yuxi
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
Monday, April 27, 2020 3:57 PM
Do you want to build log shipping between on-prem SQL Server 2014 and AWS RDS?
If you can make sure the on-prem server and AWS RDS service can communicate with each other, maybe it is possible.
Ummmm...ok....
Monday, April 27, 2020 4:09 PM
You will get a better answer if you post in the correct forum.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldisasterrecovery
Monday, April 27, 2020 4:12 PM
AWS RDS has many limitations. AWS RDS does not support Log Shipping.
However, there is no restriction if you create an EC2 instance running SQL Server. There is no difference between running an on-prem server and an EC2 server running SQL Server.
Tuesday, April 28, 2020 1:06 AM
Hi techieplaya,
Is the reply helpful?
Best Regards.
yuxi
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com