Always ON Availability Groups in SQL server - A HA-DR Solution || Ms SQL

The Always On availability groups feature is a High A-DR solution that provides an enterprise-level alternative to database mirroring.

An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. 

Configuration of Windows Failover Cluster : Click below to Watch

[srinuyadav]

As per MS, Instead of Join only...we can use Auto seeding also...if Database size having less than 200GB.

So if u use this option..no need to take full and log backup of primary and no need to restore it on Secondary....(with no norecovery option)

Thanks for sharing this video....❤

[sqltechzpestechz]

I Have one doubt, when u restore the full backup with NO RECOVERY but u didnt restore the Log backup with NO RECOVERY, then how in join only mode it gets added, in my case it throws error that no latest log backup is there. once i restore the log with NO RECOVERY then it gets added using JOIN ONLY

[anthonycurreri]

Good video, one correction, The Standard Edition of SQL server has basic availability groups included. That limits you to 1 database per group but you can have an unlimited number of groups.

[devendranavalakhe]

Your Video is very helpful. My request is to plz include the monitoring of Always ON part in this video.

[murghachronicles]

How did you create Windows Failover Cluster? Is this a separate machine or is this some kind of feature which needs to be enabled on both SQL Server nodes?

[chrisumali]

Thanks for the demo and i, have a great day

[sagarkashid]

Please make some senarios, errors and resolution in Always on

[pushkarsawant]

You deserve a lot more subscribers :) Thanks for the video

[sansak]

hi i has a doubt why windows failover cluster will failover drives right, but why we need that setup for always on, what is logical connection, always on made for group of databases but how windows cluster set up will needed for this, when feature itself supporting group of db's, can u please explaing logically how wsfc will be required for always on.

[Ganeshay-]

2019 in not showing availability on group

[abhay]

are there need to install ssms on both 102 amd 103 machine if yes how did you do that?

[JogaKhichurirabby]

In the secondary server, there is no "yes" Option for readable secondary. I am using the Standard edition of SQL.

[saikumarkakarla]

Anna tq Anna i learn so many new things from yours video, if possible DR DRLLs yala perform cheyalli high availability configured chesina databases ki video cheyandii Anna.

[SamanthaBandaraDissanayake]

Hi Great Stuff
Need to check one clarification with you,
Is there any posibility to use cross database sync, mean, One DB create on node A and it replicate node B, and other database on Node B and it replicate to Node A

[vinoddasfool]

Hello, You had a great demonstration. My question is if we are leveraging this as a SaaS solution and wanted to perform some Sanity checks once the Always On availability group is configured. Is there a preset query which I can use to do a verification check? Thanks in advance!

[ramsheddy]

Thanks a lot for this. Very easy to follow!

[x-factorgaming]

Why we need "Restore with Norecovery" option to restore in this case? Please explain sir

[johnwayne]

Can I use sql 2017 standard edition for HA groups for more then one database? At the very first screen as a clusters type I see External or None. When None is selected I can only select one database?

[suresh_bellamkondavlogs]

Hiiii bro plz explain one detailed class about daily health checklist

[saimadhav]

Hi sir can you please fwd me the scripts which DBA related daily activities