November 28, 2017 at 8:08 am
Hi all,
Am trying to figure out how to add a secondary replica always on to my on-premises SQL server, the edition is 2014. Finding it hard to get my hands on a step-by-step guide to implement this. During the search find this article but it only works if the Azure VM which should only be created using the classic deployment model. Cant seems to find the doc for VM created with Resource manager.
Can any one help?
With Regards,
B
November 29, 2017 at 5:12 am
This article shows how to use an ARM template. That should help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 29, 2017 at 8:18 am
Hi Grant,
Thanks for the link. The article is talking about setting up AG between two Azure VM's whereas in my case I am looking for one on-premises to other in Azure. Do you know if any different approach is required for this?
Regards,
B
November 29, 2017 at 11:25 am
Oops. I was so focused on finding the ARM template that I missed that part.
There is a very good document out there on it. I'll have to look around for that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 19, 2018 at 4:49 pm
Grant Fritchey - Wednesday, November 29, 2017 11:25 AMOops. I was so focused on finding the ARM template that I missed that part.There is a very good document out there on it. I'll have to look around for that.
Hello Grant..any chance you or someone else was able to find the ARM template doc? I am also looking for the same thing.
September 20, 2018 at 4:58 am
alliedDBA - Wednesday, September 19, 2018 4:49 PMHello Grant..any chance you or someone else was able to find the ARM template doc? I am also looking for the same thing.
Pretty sure this is the one I meant.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 20, 2018 at 5:58 am
Thank you Grant. I reviewed it and the section above says its applicable to Classic deployment model. I believe I can use this TSQL for the Resource manager model that I have then?
One question I have is, do I need an Internal Load Balancer configured in Azure to set up the Listener? or will a Static IP be sufficient? Given this node is in a different subnet compared to my primary node on site?
The purpose of the Azure node is for read only connections only, not looking to failover in near future.
September 20, 2018 at 6:01 am
alliedDBA - Thursday, September 20, 2018 5:58 AMThank you Grant. I reviewed it and the section above says its applicable to Classic deployment model. I believe I can use this TSQL for the Resource manager model that I have then?One question I have is, do I need an Internal Load Balancer configured in Azure to set up the Listener? or will a Static IP be sufficient? Given this node is in a different subnet compared to my primary node on site?
The purpose of the Azure node is for read only connections only, not looking to failover in near future.
You are stepping a little outside my comfort zone on this. I'd suggest posting it as another question here on SSC. Someone with more knowledge of the network comms can answer then.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply