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
• Windows Failover clust...
Endpoints in SQL server : • Endpoints in SQL serve...

[@srinuyadav1629]

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

[@righttolearnbk]

Auto-seeding is available from SQL server 2016 onwards only.

[@srinuyadav1629]

@@righttolearnbk yes sir after 2016 only this AG concept was introduced. Before 2016 we configured DB mirroring.

[@devendranavalakhe8060]

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

[@damodhardaamu9925]

Well explaining bro

[@anthonycurreri1543]

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.

[@pushkarsawant7449]

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

[@chrisumali9841]

Thanks for the demo and i, have a great day

[@sagarkashid123]

Please make some senarios,errors and resolution in Always on

[@sairavi8806]

I am having doubt here . When the primary is off it will switch to secondary and do the operations..... But when the primary is up.. the next operation will go to primary or secondary??

[@ramsheddy]

Thanks a lot for this. Very easy to follow!

[@murghachronicles715]

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?

[@sqltechzpestechz7053]

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

[@sqltechzpestechz7053]

thank u so much🥰

[@saikumarkakarla9924]

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.

[@righttolearnbk]

Ok.

[@suresh_bellamkondavlogs]

Hiiii bro plz explain one detailed class about daily health checklist activities.....

[@abhay6276]

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

[@righttolearnbk]

If you want to connect your server from any node and work then install otherwise not required. Just copy SSMS installer in machine and install it

[@Ganeshay-996]

2019 in not showing availability on group

[@hasinihasini5562]

Thx for your efforts

[@JogaKhichurirabby]

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

[@vinoddas1981fool]

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!

[@x-factorgaming4265]

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

[@P5toraskar1986]

Super efforts.

[@ericrouach]

Great content!

[@sansak9098]

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.

[@synthmania7275]

Thank you!

[@shamilpm262]

Thanks a lot for this , Is it have any Diagrammatic form

[@harishreddy4]

Hi Sir, Can we deploy the SQL server failover cluster instance while configuring availability group instead of stand alone instance?

[@righttolearnbk]

SQL Server Failover Cluster Instances do not support automatic failover by availability groups, so any availability replica that is hosted by an Failover cluster instance can only be configured for manual failover.

[@harishreddy4]

Thank you,sir

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

[@piyusworld2550]

DNS name you have given is already created or we have to mention while configuration ALways On AG?

[@ramakrishnakasani9152]

How we did cluster less setup in always-on

[@righttolearnbk]

Cluster was already setup.

[@ramakrishnakasani9152]

@@righttolearnbk without using clustering it is possible to setup always-on

[@righttolearnbk]

@@ramakrishnakasani9152 No Without windows clustering we cannot setup Always on

[@labib8aug]

@@righttolearnbk actually we can , check the updated version.

[@johnwayne4230]

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?

[@righttolearnbk]

2017 Standard Edition supports basic availability groups. A basic availability group supports two replicas, with one database. Check below link for Microsoft documentation on basic availability groups learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups

[@prashantbhosale5635]

And also few scenarios and three node clusters

[@saimadhav672]

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

[@bobbalaparshu336]

Thanks for your efforts. How do we add ndf files on database in always on group. If possible could you please make a video on always on trouble shooting issues and performance tuning issues.

[@righttolearnbk]

While adding NDF file please make sure you have same physical location in the nodes

[@mdkaif786]

Hi Sir May i kindly request you to please share a step by step docs or video how to Fail Over from Production to DR and from DR to production. Thanks Sir...

[@prabhu0408]

Hi Bro, Nice video. in terms of the SQL Server Installation, could you please let me know 2019 std or 2019 Enterprise needed? in production. Thanks

[@righttolearnbk]

Standard will do your job. Go for enterprise if you need more advance features

[@prabhu0408]

@@righttolearnbk Thank you

[@fbifido2]

Can you show how to do standalone SQL alwaysOn AG /w listener in a workgroup env?

[@rajesh9618962370]

Hi mate, what is difference in restart of sql service and stop-start..

[@ShreyaSreejith2013]

Restart will stop and start the services automatically.Stop and Start are manual activities to stop and start services manually

[@avulasatishpatel2545]

Availability replica is not synchronizing Create video for both if primary not synchronizing Next Secondary not synchronizing

[@Jayadhev]

Please make a veedio on always on interview questions

[@surekhaanupoju4730]

Thanku sir

[@dollardreams5811]

Hi sir Suppose my manager told to you are the owner of 1tb database what was the things I need to be take care of the database for the minimum downtime

[@righttolearnbk]

Few things you can do is To Perform health check on regular basis, deploy High availability as per your client's requirements, have a backups maintenance plan, and configure alerts If you gonna migrate it, use Azure Data Migration service.

[@thirupathiraot2207]

We configure AG only on Mirroring configured DBs only

[@righttolearnbk]

No

[@sahithyabolly8018]

Hi , I need to clear some interviews can you help me...

[@righttolearnbk]

Hello, do you need Q&A ??

[@dollardreams5811]

Please post a videos about replication and clustering

[@righttolearnbk]

I will do it as soon as possible

[@naniprabha4410]

I need MS SQL DBA support can u provide

[@righttolearnbk]

Yes

[@venkannavenkanna9882]

i can support SQL DBA

[@AT-tb1hf]

@@righttolearnbk Hi i need assistance to clear interview can u plz help me .

[@chaitu6542]

Can I have upgrade and migration videos bro

[@prashantbhosale5635]

Please show some errors

[@righttolearnbk]

Sure, will do scenario based videos in coming days

[@thirupathiraot2207]

??