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

[@devendranavalakhe8060]

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

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

[@chrisumali9841]

Thanks for the demo and i, have a great day

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

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

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

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

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

[@damodhardaamu9925]

Well explaining bro

[@sagarkashid123]

Please make some senarios,errors and resolution in Always on

[@ramsheddy]

Thanks a lot for this. Very easy to follow!

[@x-factorgaming4265]

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

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

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

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

[@hasinihasini5562]

Thx for your efforts

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

[@sqltechzpestechz7053]

thank u so much🥰

[@ericrouach]

Great content!

[@P5toraskar1986]

Super efforts.

[@piyusworld2550]

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

[@JogaKhichurirabby]

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

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

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

[@shamilpm262]

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

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

[@OMNS777]

Thank you!

[@fbifido2]

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

[@suresh_bellamkondavlogs]

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

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

[@Ganeshay-09]

2019 in not showing availability on group

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

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

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

[@sahithyabolly8018]

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

[@righttolearnbk]

Hello, do you need Q&A ??

[@prashantbhosale5635]

And also few scenarios and three node clusters

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

[@surekhaanupoju4730]

Thanku sir

[@avulasatishpatel2545]

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

[@thirupathiraot2207]

We configure AG only on Mirroring configured DBs only

[@righttolearnbk]

No

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

[@Jayadhev]

Please make a veedio on always on interview questions

[@chaitu6542]

Can I have upgrade and migration videos bro

[@dollardreams5811]

Please post a videos about replication and clustering

[@righttolearnbk]

I will do it as soon as possible

[@thirupathiraot2207]

??

[@prashantbhosale5635]

Please show some errors

[@righttolearnbk]

Sure, will do scenario based videos in coming days