Our network admin created a cluster (vmware using shared disks seetings - 2 nodes) so plan to install SQL Server AlwaysOn. After some trial and error, it now has passed the cluster validation and I can continue to install SQL.
Are my next steps correct?
[1] Install SQL Server 2019 on both nodes as a STAND-ALONE install
[2] Then configure AlwaysOn Availability Group after.
Reason I'm asking is that on the SETUP, there is an option for a "NEW SQL Server Failover cluster Installation" so I'm not sure which one to use.
Thanks
April 29, 2020 at 9:40 pm
Your steps are correct for AlwaysOn - you install stand-alone instances on each server in the cluster and then configure an availability group.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
OK So I watched 2 youtube videos and below helped me setup what I need.
https://www.youtube.com/watch?v=pmTK5Um_9bw
In a nutshell, I did not follow my proposed steps 1&2. As with the tutorial, I went ahead and installed as follows:
[1] "New SQL Server Failover Cluster Installation" on the Active Node
[2] Used the "Add a Failover Cluster Node" after on the other node.
Thanks!
April 30, 2020 at 7:40 am
Glad you where able to install.
As a side note please remember that "Always On" is just a marketing term from Microsoft. Always On can refer to Always On Failover Cluster Instances or Always On Availability Groups. So generally the Always On portion is removed to understand the correct setup.
Failover Cluster Instances utilise the shared disk setup
Availability Groups utilise dedicated disks per replica
So you can define the correct install methods usually based on the disk configuration.
May 9, 2020 at 9:25 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply