How to Create SQL 2019 Always ON High Availability Step by Step Guide

Подписаться 6 тыс.

Просмотров 11 тыс.

50% 1

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

Наука

Опубликовано:

11 июн 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 34

@fernandomori9351 2 месяца назад

Great explanation Muhammad had already watched some on RU-vid 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

@SantoshKumarSharma08 2 месяца назад

Thanks, wonderful .

@AzmathShaik-fn2hs Месяц назад

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.

@RealityCheck22151 28 дней назад

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.

@gregoryrmadriz Год назад

Thank you very much Muhammad for all your time and effort, Excellent.

@nayyarnayyar100 Год назад

GREAT .... YOU EXPALINED NICELY

@shehzadarshad2000 Год назад

Thanks bro

@SantoshKumarSharma08 2 месяца назад

Please also add witness server.

@piyushsoni5727 6 месяцев назад

Sir SQL server indexing parvideo banaye

@allaboutsqldata4810 Год назад

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)

@shehzadarshad2000 Год назад

Hahahahha u know mother taungue always in 🤣👌

@nayyarnayyar100 Год назад

LAAZMI

@nayyarnayyar100 Год назад

LAAZMI = MANDATORY

@allaboutsqldata4810 Год назад

thanks

@piyushsoni5727 6 месяцев назад

Hello sir . Your video is very usefull and am requesting the you make SQL server on indexing video

@nirajsinha2509 9 месяцев назад

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.

@1ajaypaul 23 дня назад

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

@AnilSingh-433 Год назад

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 ?

@chanderkant3889 11 месяцев назад

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

@syedirfanhaider2346 Год назад

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?

@shehzadarshad2000 Год назад

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 .

@itcloudknowledge5237 Год назад

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?

@shehzadarshad2000 Год назад

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

@testamen8642 14 дней назад

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

@shehzadarshad2000 14 дней назад

see my new video about always on step by step ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WzDkBujoXdw.html

@naveedchaudhry2700 8 месяцев назад

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

@muhammadfahad4091 7 месяцев назад

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

@sourabhdey2590 Год назад

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

@josemanuelduran8601 Год назад

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

@nickleex Год назад

Buen punto José

@josemanuelduran8601 Год назад

@@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.