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

Подписаться 12 тыс.

Просмотров 84 тыс.

50% 1

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

Опубликовано:

20 дек 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 68

@ramsheddy 2 года назад

Thanks a lot for this. Very easy to follow!

@devendranavalakhe8060 Год назад

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

@chrisumali9841 Год назад

Thanks for the demo and i, have a great day

@pushkarsawant7449 Год назад

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

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

@anthonycurreri1543 27 дней назад

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.

@hasinihasini5562 Год назад

Thx for your efforts

@P5toraskar1986 2 года назад

Super efforts.

@suresh_bellamkondavlogs 2 года назад

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

@ericrouach Год назад

Great content!

@piyusworld2550 2 года назад

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

@synthmania7275 6 месяцев назад

Thank you!

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

@murghachronicles715 13 дней назад

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?

@srinuyadav1629 4 месяца назад

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 2 месяца назад

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

@srinuyadav1629 2 месяца назад

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

@sagarkashid123 2 года назад

Please make some senarios,errors and resolution in Always on

@sansak9098 2 года назад

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.

@shamilpm262 Год назад

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

@surekhaanupoju4730 2 года назад

Thanku sir

@JogaKhichurirabby Год назад

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

@SamanthaBandaraDissanayake 5 месяцев назад

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

@bobbalaparshu336 2 года назад

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 2 года назад

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

@x-factorgaming4265 Год назад

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

@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 3 года назад

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

@righttolearnbk 3 года назад

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 3 года назад

Thank you,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?

@mdkaif786 8 месяцев назад

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

@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

@prashantbhosale5635 3 месяца назад

And also few scenarios and three node clusters

@dollardreams5811 3 года назад

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 3 года назад

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.