@@Harsha_vardhan1 Hi Harsha it's not wrong if we can say AG is server level but the thing is we can't replicate server level logins and jobs etc., so in my openion AG is not a server level even though we can add all the databases to AG.
No, It is a database level, because we can't share the resources(eg. drive) between servers or nodes. its an mix of mirroring(fast data synchronization& automatic failover without witness server),and Log shipping (one to many relation, and secondary is readable).Only clustering is server level! and always on only need window clustering for the availability group to be created as a role so we can do a manual failover , but we don't need SQL clustering for always on! we install standalone sql instance on the primary replica, and we add a the sql instance on the existing node on the secondary replica. I hope it will help
@@manivenkata9912 I don’t have any institution, I am a working professional and teaching is my passion. If you want training please email me so that I can provide my contact details. Solvedpages@gmail.com
Very nice and detailed interview, He answered every question in detail and clear.
@@AnkitSingh-hi1rm Thank you so much
Oh its really helpful 😊
Thank you 🙏
He must be having minimum 5 years experience as a SQL dba
@@yashwanth6879 who me??
This video was very helpfull ma'am❤
just one thing you do remove the double voice
@@spyro_akki1595 Thank you, we will work on it
Nice
Thank you 🤝🤝
Nic video, one doubt Alwayson is server level high availability right?
@@Harsha_vardhan1 Hi Harsha it's not wrong if we can say AG is server level but the thing is we can't replicate server level logins and jobs etc., so in my openion AG is not a server level even though we can add all the databases to AG.
No, It is a database level, because we can't share the resources(eg. drive) between servers or nodes. its an mix of mirroring(fast data synchronization& automatic failover without witness server),and Log shipping (one to many relation, and secondary is readable).Only clustering is server level! and always on only need window clustering for the availability group to be created as a role so we can do a manual failover , but we don't need SQL clustering for always on! we install standalone sql instance on the primary replica, and we add a the sql instance on the existing node on the secondary replica. I hope it will help
@@bezatefera4419Thanks and really helpful 😊 I ageee 😊
Try to upload more vedios..
Sure, I am working on it.
Can we contact for real time scenarios explanation videos
solvedpages@gmail.com
If you have institute please provide your detials so that i will also join
Reply sir
Can we get one for freshers plz.
@@soniyashende4560 Sure, I will upload one with in a week.
May I know you have any institute
@@manivenkata9912 I don’t have any institution, I am a working professional and teaching is my passion. If you want training please email me so that I can provide my contact details. Solvedpages@gmail.com