SQL Always on AG - Azure | Deploy SQL Always on Availability Group in Azure - Step by Step Demo New

☕ Support us: www.buymeacoff... ☕
Learn Exchange Server / Hybrid / Migration / DAG full course from:
Course 1: ⚡ Exchange Server Training ⚡: www.udemy.com/...
Course 2: ⚡ MS 100 Microsoft 365 Identity and Services ⚡: www.udemy.com/...
Suggest a Topic:
forms.office.c...
In this video, you will watch how to setup SQL Always on Availability Group in Azure from scratch.
Topics Covered:
what is a database ?
what are the different editions available?
what is HA?
Different methods for HA
Always on AG in detail
Demo:
-Setup Virtual Machine and Network for Domain Controller and SQL Servers
-Create Windows Fail over Cluster with cloud witness
-Install and Setup SQL Server Developer Edition
-Setup Always on AG, Listener
-Azure Internal Load balancer
-Test Fail over

[@ikn0wn0thing.]

Thank you very much for your explanation

[@sandsandeeps]

Niyaz thanks for making great videos , all are great, thanks a ton.....

[@vonschwarcz]

Can I use Entra ID authentication?

[@duvalldanganan]

Thank you! very helpful video!

[@venkatraohyd]

Very nice and good demo. Can we do the same between GCP vm on which SQL is with failover clusters and want to move it to azure. Is there any such demo ? Thanks again for such a great demo.

[@ritikarora2210]

Can't we use the same windows server on which one of the node is installed for setting up the domain controller ?

[@kadirbek5712]

Thanks for explaining all the details which is super helpful. A quick question, how to configure Listener for multi-subnet environment ? for example, locating secondary replica at DR side?

[@RajpalMathangi-s9v]

quick question- how do we mark/reserve listener IP as "Static" in Azure portal?

[@markrawson1435]

How do you setup the azure load balancer if your second SQL server is in a different region and different vnet?

[@Raj_xrt]

Helpful video, thanks.

[@pa1089]

Good one Niyas. Is the floating IP not required here? Thank you

[@surajsalvi4497]

Sir one of my node server is not get automatically replicate do you have any solution

[@joseluisllumiquinga9092]

Excellent video, but I have a problem. When I try to add the second SQL to validate the FailoverCluster configuration I have the following error: You do not have administrative privileges on the server SQL2......

[@michaelitegbe3789]

hello , did you et a solution, i am having thesame issue now

[@musicology99]

The video is very useful Bro, please post videos on azure Sql db backup with backup and restore steps

[@AymanNady]

Can we have a PowerShell

[@supriyochatterjee4095]

Awesome Video Sir,Please upload more videos related to Azure,AWS troubleshooting related to real world scenarios and industry applications

[@itproguide]

Sure I will

[@sivareddymallu796]

Could you please provide the document for this

[@Satishma]

Pease post those powershell commands in comment of description. otherwise its a nice video demo.

[@gislentim8425]

this was a good tutorial but you got one confused with the last part, not showing us what you ran on Powershell

[@narayanan5245]

Nice Video. Thanks so much. One question, there are no steps of integrating the local storage disks to sql for data and log. Can you please update that as well?

[@rajesh861000]

Very helpful video..thanks!

[@RajneeshDabral]

Great video. Thanks