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

[@sandsandeeps]

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

[@duvalldanganan]

Thank you! very helpful video!

[@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?

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

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

[@musicology99]

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

[@RA-bn1xi]

Helpful video, thanks.

[@RajneeshDabral]

Great video. Thanks

[@pa1089]

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

[@user-wn1ns2kc5s]

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

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

[@markrawson1435]

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

[@ritikarora2210]

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

[@gislentim8425]

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

[@Satishma]

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

[@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?

[@surajsalvi4497]

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

[@AymanNady]

Can we have a PowerShell

[@sivareddymallu796]

Could you please provide the document for this

[@rajesh861000]

Very helpful video..thanks!