April 11, 2025 at 11:54 am
Hi Everyone,
I have a question, I am trying to setup a Lab environment with 1 DC and 2 SQL Nodes , both 2 SQL servers already joined on the domain and already setup a WSFC with 1 witness File share setup on the DC(Lab purposes), I've already created a dedicated virtual disk for the sql data and log files(hosted also on DC server), The goal is to have running SQL Server Always-on FCI, I'm torn between choosing the installation of SQL server on Stand alone and the other one is SQL server Failover cluster installation, also when I choose either of the two then I choose the drive where the instance will be installed , I have error prompted that the instance unable to installed on a clustered disk when I choose the drive where virtual disk provisioned, can you someone enlighten me about it or give me a direction link to read on.
Thank you in advance.
April 12, 2025 at 12:30 am
Why do you need a clustered disk? You need a shared location where all the nodes can access files to synchronize themselves.
Check this links:
https://www.sqlservercentral.com/articles/steps-for-installing-alwayson-availability-groups-sql-2019
https://kevinholman.com/2022/09/28/sql-always-on-step-by-step/
https://www.sqlshack.com/configuring-a-sql-server-alwayson-high-availability-group/
=======================================================================
April 12, 2025 at 7:03 am
Thank you for the replied and links , gonna read it, I think I’m thinking the wrong way in terms of WSFC. I think working on SQL AOAG does not mean I need to have a clustered disk for the sql instance and residing the sql instance there including the data and log files. I am just thinking if that would be possible. I am just wondering to install a sql instance with data ang log files on shared clustered disk in one node only, since I have configured the 2 nodes as WSFC.
April 20, 2025 at 7:56 am
Why do you need a clustered disk? You need a shared location where all the nodes can access files to synchronize themselves.
Check this links:
https://www.sqlservercentral.com/articles/steps-for-installing-alwayson-availability-groups-sql-2019
https://kevinholman.com/2022/09/28/sql-always-on-step-by-step/
https://www.sqlshack.com/configuring-a-sql-server-alwayson-high-availability-group/
@Emporer100: The post is about FCI not availability groups.
April 20, 2025 at 10:50 am
Thanks for sharing your setup – sounds like a great learning environment. When configuring SQL Server Always On Failover Cluster Instances (FCI), you’ll need to make sure you select SQL Server Failover Cluster Installation, not the standalone option. Also, SQL Server FCI requires the installation to be done on shared clustered storage that's recognized by the Windows Server Failover Cluster (WSFC), not just a regular virtual disk.
If you're getting an error about installing on a clustered disk, double-check that the disk is added as a Cluster Shared Volume (CSV) and is available to all nodes in the cluster. It should also be online and assigned to the SQL Server role in the Failover Cluster Manager.
Good luck with the lab – it's a great way to get hands-on with HA setups!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy