Installing a SQL Server Failover Clustered Instance (SQL Server 2022 Edition) - Part 3
Vložit
- čas přidán 1. 04. 2024
- This is an update to the video on SQL Server failover clustering installation. We will build a traditional 2-node SQL Server 2022 failover clustered instance on Windows Server 2022 - from start to finish.
Part 3 is all about installing patches and updates on a SQL Server 2022 failover clustered instance.
Make sure you watch until the end. I've included the process on how to slipstream SQL Server updates as part of the SQL Server 2022 failover clustered instance installation
Part 1 is available here: • Installing a SQL Serve...
Part 2 is available here: • Installing a SQL Serve...
Download the Cluster Preparation Check list from here
learnsqlserverhadr.com/cluste...
Bro im becoming your fans , this tutor really helpful , subscribed and please do another good job again for sql server 🎉🎉🎉
Can CUs be applied by just pausing a node and draining the roles and vice versa?
I do not recommend the node drain feature for SQL Server. It wasn't designed with SQL Server in mind. It's for Hyper-V workloads
Pls make video on always on high availability also.
Have a look at this
czcams.com/video/DmH81mGGZwg/video.html
@@EdwinMSarmiento can you make a video on how to configure the on always on high availability and it failover. What is the different between the normal HA and the always on HA, thanks.
@@jeffreyooi1971 Are you referring to this?
czcams.com/video/A8lSl8nO1r4/video.html
@@EdwinMSarmiento is it the same configuration or setting apply to SQL server 2022 too as the video is 12 years ago, thanks.
@@jeffreyooi1971 There have been a lot of configuration changes since SQL Server 2012. And these subtle changes can cause a major outage if not done properly.
I'll release an updated video on installing and configuring SQL Server Always On Availability Groups