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.
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....❤
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.
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.
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!
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?
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
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?
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
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
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??
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.
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.
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...
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
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.
You deserve a lot more subscribers :) Thanks for the video
Thanks for the demo and i, have a great day
Your Video is very helpful. My request is to plz include the monitoring of Always ON part in this video.
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.
Please make some senarios,errors and resolution in Always on
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....❤
Auto-seeding is available from SQL server 2016 onwards only.
@@righttolearnbk yes sir after 2016 only this AG concept was introduced.
Before 2016 we configured DB mirroring.
Thanks a lot for this. Very easy to follow!
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.
Ok.
Why we need "Restore with Norecovery" option to restore in this case? Please explain sir
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.
are there need to install ssms on both 102 amd 103 machine if yes how did you do that?
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
Hiiii bro plz explain one detailed class about daily health checklist activities.....
In the secondary server, there is no "yes" Option for readable secondary. I am using the Standard edition of SQL.
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!
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?
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
Well explaining bro
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?
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
thank u so much🥰
Thx for your efforts
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
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??
Thanks a lot for this , Is it have any Diagrammatic form
DNS name you have given is already created or we have to mention while configuration ALways On AG?
How we did cluster less setup in always-on
Cluster was already setup.
@@righttolearnbk without using clustering it is possible to setup always-on
@@ramakrishnakasani9152
No
Without windows clustering we cannot setup Always on
@@righttolearnbk actually we can , check the updated version.
Great content!
Can you show how to do standalone SQL alwaysOn AG /w listener in a workgroup env?
2019 in not showing availability on group
Super efforts.
Hi Sir,
Can we deploy the SQL server failover cluster instance while configuring availability group instead of stand alone instance?
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.
Thank you,sir
Hi sir can you please fwd me the scripts which DBA related daily activities
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.
While adding NDF file please make sure you have same physical location in the nodes
Hi mate, what is difference in restart of sql service and stop-start..
Restart will stop and start the services automatically.Stop and Start are manual activities to stop and start services manually
Thank you!
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...
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
Standard will do your job.
Go for enterprise if you need more advance features
@@righttolearnbk Thank you
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
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.
We configure AG only on Mirroring configured DBs only
No
And also few scenarios and three node clusters
Please make a veedio on always on interview questions
Thanku sir
Hi , I need to clear some interviews can you help me...
Hello, do you need Q&A ??
Availability replica is not synchronizing
Create video for both if primary not synchronizing
Next
Secondary not synchronizing
I need MS SQL DBA support can u provide
Yes
i can support SQL DBA
@@righttolearnbk Hi i need assistance to clear interview can u plz help me .
Please post a videos about replication and clustering
I will do it as soon as possible
Can I have upgrade and migration videos bro
Please show some errors
Sure, will do scenario based videos in coming days
??