March 28, 2018 at 12:02 pm
We are planning to install a SQL server 2017 standard. But in near future we probably will create another instance on another site for mirroring this server.
I know standard edition has basic availability group feature. My question is can we install SQL server first, and later if we need the second server, then configure the windows cluster.
Or we have to configure windows cluster now before install SQL server in order to use availability group in future?
Thanks much
March 29, 2018 at 3:13 am
Personally I would create the cluster at the start, all be it a 1 node cluster and enable the AOAG feature, as doing that later needs a restart of the service and if you dont have downtime when adding in other replicas then you cant do it.
But you then may have downtime so its an "It Depends" answer.
Also depending on your version of the Operating Sytem you could also look at clusterless AOAGs
March 29, 2018 at 8:14 am
sqlfriends - Wednesday, March 28, 2018 12:02 PMWe are planning to install a SQL server 2017 standard. But in near future we probably will create another instance on another site for mirroring this server.
I know standard edition has basic availability group feature. My question is can we install SQL server first, and later if we need the second server, then configure the windows cluster.
Or we have to configure windows cluster now before install SQL server in order to use availability group in future?Thanks much
You can start with standalone machines and create the WSFC later, this has no effect on any instances you may have installed.
You would need to enable the instances for AGs once the WSFC has been formed.
Are you planning to use Windows 2016 as the Server OS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2018 at 8:16 am
anthony.green - Thursday, March 29, 2018 3:13 AMAlso depending on your version of the Operating Sytem you could also look at clusterless AOAGs
These are not as easy to setup as a traditional WSFC, they also have various limitations.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 29, 2018 at 9:40 am
Thank you.
I use standard edition of SQL server 2017 on windows 2016.
So I guess I can only use the Basic availability group. Above you described also applies to BAG too. Correct?
We can have downtime for this case. So probably we can do it later.
March 29, 2018 at 11:22 am
sqlfriends - Thursday, March 29, 2018 9:40 AMThank you.
I use standard edition of SQL server 2017 on windows 2016.
basic only then
sqlfriends - Thursday, March 29, 2018 9:40 AM
So I guess I can only use the Basic availability group. Above you described also applies to BAG too. Correct?We can have downtime for this case. So probably we can do it later.
Yes, you can form the cluster later and setup the group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2018 at 11:45 pm
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply