0

We are already having an SQL Server Enterprise Edition instance running on an Physical Server. Now to configure AlwaysOn Availability Groups

  1. Can we configure WSFC (Windows Server Failover Cluster) Services on existing SQL server instance?
  2. Or uninstall SQL Server, install WSFC and then install SQL again? (this may not be a best thing, as they are holding huge DB's.)

As we are planning a 3-node (all are physical machines and currently running SQL instances) cluster, how to move ahead? What options to select from the installation media to proceed with AlwaysOn Availability Groups configuration. Thanks

asked Sep 5, 2021 at 19:17
1
  • I'm fairly sure that you can enroll an existing server into WSFC without needing downtime. If it's not already part of a cluster, you may need a downtime to add AG capability to the server - I don't remember if it takes the instance offline to do that or not. Commented Sep 6, 2021 at 4:49

1 Answer 1

0

You can do it without sql reinstall. Only some reboots.

Install WSFC, add nodes with existing sql server.

Then enable alwayson in the configuration manager:

enter image description here

answered Sep 6, 2021 at 6:31

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.