How to Create SQL 2019 Always ON High Availability Step by Step Guide
Vložit
- čas přidán 11. 06. 2022
- Welcome to my channel in this video I would like to show " How to create SQL 2019 Always on high availability" if you have liked my video kindly do not forget to "Like" "Subscribe" and hit the bell icon for upcoming videos.
//How to install Microsoft SQL Server Always On
//How to configure Microsoft SQL Server Always On
//Microsoft SQL Server Always On
#HowToConfigureSQLAlwaysOn #sqlalwayson #SQLHA #HowtoinstallMicrosoftSQLServerAlwaysOn #Database #SQLServer #SQLServerInstallation #MicrosoftSQLServer
tags:-
sql server,sql,sql server 2019,how to configure alwayson in sql server 2016 step by step,sql always on,sql setup always on availability group,sql 2019,sql alwayson,how to configure alwayson,sql cluster alwayson,sql cluster,sql alwayson step by step,sql alwayson configurations,sql tutorials,how to configure sql alwayson step by step,SQL Always On,Alwayson,How,to,configure,Always,On,microsoft sql server,sql server tutorial,sql server management studio - Věda a technologie
Great explanation Muhammad had already watched some on CZcams from other guys, but yours was too deep, innovating the explanations of how to get out of a problem when you are explaining it... congratulations
Thank You So Much for your time...I am impressed the way you have explained. While creating AG group its not getting through the step Joining replica server to availability group which is the last step since we need to add the one more port number 5022 which is endpoint as inbound rule in windows firewall in both nodes. Finally i have created successfully THANK YOU SO MUCH.
Great video for Urdu speaking world. Few suggestions.
they way you set it up is okay for home lab and for people new to SQL Server AOAG but not for real production environments. The security team will never let it fly due to several security violation flaws that are most probably "CAT I" findings in STIGs like not disabling "sa" account, not using service accounts for SQL services, granting full control to users etc. Also the last step "creating listener", all you had to do was to grant "Add Computer Object" permissions to CNO (cluster name object) for listener to work.
Also, this covers HA part of HADR, what about creating another node for DR on a different subnet?
Again, great effort.
Regards.
Thanks, wonderful .
Thank you very much Muhammad for all your time and effort, Excellent.
GREAT .... YOU EXPALINED NICELY
Thanks bro
hi, i received the following error when trying to validate cluster, adding the second node to cluster.
"you do not have administrative privileges on the server." any idea?
its weird I can however add both nodes from node 2.
is it possible to make a cluster between a windows 2012 and 2019 servers?
any help would be appreciated
Many thanks in advance
Good morning Shehzad,
Aapko bahut bahut dhanyawad ki aapne itna achha se es video me Always On High Availability explain kiya hai. Maine bhi almost same lab banaya hai jaisa ki aapne es video me bataya hai. Main ek jagah aa kar atak raha hoon. Kripya mujhe guide kare. Database name is test.
Wizard ke through SQLAG group banate samay last me jab main Finish kiya to sara Success show kar raha hai. Sirf last option (Joining 'test' to availability group 'SQLAG' on 'SQLNODE2') me 'In Progress' show kar raha hai. Bahut wait karne ke baad jab nahi hua Success to main es SQLAG group ko delete kar diya. SQLNode2 me bhi database 'test' copied ho gaya tha usko bhi delete kar diya. DC1 me bhi check kar liya ki SQLAG name ka kuchh show nahi kar raha tha. Aur maine dubara se different name 'SQLAGR' se AG Group banaya. Phir bhi same jagah hi aa kar atak rahi hai.
Please help kare.
Thanks in advance.
Really appreciated your effort... Every point explained with Good Example and enough time to explain. I think, after your watching video.. No need to check other thing except some troubleshooting issue.. Now your full video captured into our Mind like movies which will never erase...
One more thing, I have also never seen (as a developer background), How DC is created and add map computer node, cluster node and you have explained very beautiful way with DNS config..
Only one word lagmi which i dont know, may be its new word for me :) (Just for kidding)
Hahahahha u know mother taungue always in 🤣👌
LAAZMI
LAAZMI = MANDATORY
thanks
Hi Shehzad,
First of all thanks for this video. Very well explained.
I have one scenario for DC DR activity. Need your guidance to avoid any kind of failure.
Node 1 : Primary - - - DC-1
Node 2 : Secondary--DC-2
Node 3: File Share----DC-1 Witness - - Standalone Machine [Protected VM]
If I shutdown primary replica which is in DC-1 then secondary replica will become primary replica which is in DC-2. Now. If I shutdown node 3 File Share Witness and it will take 30 min to move DC-2. During movement of file share witness node what will be the status of Availability Group. And when it will move successfully on DC-2 then will it up the primary replica in DC-2 or there will be manual intervention required.
Please suggest How to plan this activity.
Thanks
Hello sir . Your video is very usefull and am requesting the you make SQL server on indexing video
Sir SQL server indexing parvideo banaye
Please also add witness server.
Great video... Kindly let me know one thing. If i have installed WSFC role in both nodes with sqladmin user which has domain admin privilege, after configuring every thing want to open wsfc console with normal domain account which has local admin privilege on both nodes, Will that account be able to connect to failover cluster ?
Hi, I am unable to join the database to availability group it stuck and in status it shows in progress (while creating Availability Group). Any help would be appreicated
Hey, i will say thank you but,, im stuck on Joining to availability group on second node. this stuck status is still "in progress".. how long must i wait? please answer me
see my new video about always on step by step czcams.com/video/WzDkBujoXdw/video.html
great sir you have very nicely, I have a question how to manage with application mean how our application switch from master database or primary database to secondary during network down or any other issue?
Hi irfan there are 2 main reasons which could switch the database to the secondary server No.1 network down between two servers unreachable , No. 2 Primary server is down .
Hello Mr Shehzad Ji I have configured as per you guide, but I just wanted to know what will happens when I will replicate both node to DR Site another site where ip range (subnet) will be different. Will my cluster , AG and Listener will work?
Hi bro u may try but as per my experience it will not work if u r moving on Dr side with different subnets and ranges
Hi shehzad, I am following your video from starting and i am facing an issue when i am trying to validate cluster in failover cluster manager and try to select nodes in Browse than screen is rolling back. Kindly resolve this issue
Sir I have followed your step completely but I am unable to join the database to availability group it stuck and in status it shows in progress
Agradezco de antemano el video, porque ha venido bien, pero tengo que poner un pero que se escapa, pero por mucho.
Según veo, cuando ya está montado todo y está empezando a configurar el always on, crea una BBDD llamada test, pero cuando empieza a tener problemas para conectarse al nodo 2 (Era claro que no habían habilitado el puerto 1433 en ambos nodos para la admin remota), aparece la magia, una vez que conecta, aparece una BBDD llamada DBV1 (y toda la configuración always on, no existe). ¿Puede alguno indicarme que configuración se ha puesto?.
Gracias
Buen punto José
@@nickleex Soluciionado, a veces hay que quitarse el miedo y ponerse a hacer cosas. Para que todo funcione correctamente hay que habilitar lor siguientes puertos del firewall, o desactivarlo. 1433, 1434, 4022, 135, 5022, 2383 ,2382, 80 y si vas a usar certificados 443.
C'est dommage !! 😢😢😢