SQL Server High Availability and Disaster Recovery overview

A high-level overview of the HA/DR options in SQL Server
6:48 Backup and Restore
9:21 - Log Shipping
14:42 - Failover Clustering
19:22 - Database Mirroring
23:13 - Availability Groups

[lordmunni]

This video fits absolutely exactly what I needed to understand so I can explain it to my boss.
Thank you very much!

[dixit]

Really good explanation ! Clears some basic doubts when learning about Availability Groups and Disaster Recovery.

[krishtheindian]

Up to the point and clear!! Thanks much!!

[Kelmebrahtu]

thank you Kevin, very well explained .

[TravellerPande]

Thanks Kevin! Very informative video. Learnt a lot!

[vishalpechetty]

Thank you so much Kevin! Very well explained

[TheKraphtOfSkill]

Very helpful explanation. Thank you Kevin.

[davidshen]

thanks for the explanation, very useful.

[raghuvnr]

Thank You, Kevin, you have simplifed!

[eyerusalemful]

Thank you very much, It was so perfect and what I need to u derstand

[DLPTonyATL]

Good morning. I have an on premise SQL HA environment and would like to add another SQL instance running in AWS to the on premise's High Availability Group. Do you have an article or a video I can review?

[drpglobalsolutionsllc]

Outstandingly Exactly what I needed to train some people on.

[tom]

Kevin, you said you weren't sure why you would need a 5th node around the 31:50 mark. I was thinking that you run reports on node 4 and that you run your third party backups and replications on node 5 (ie veeam)?

[tusharjain]

Thanks Kevin. This give goods insight.
Do mirroring also automatically handle column level TDE(encryption)?

[Signofnothing]

Great presentation, just for curiousty, is there a tech as cheap as LS and if it is going ti continue to operate

[gajendra-]

hi can you share step by step configuration to HA with failover(wsfc)

[jorgesmitley]

Great video Are the Availabiltiy Groups similar to Exchange DAGs? Are you able to have active active with the Availability Groups or would that be a limitation on the Windows Clustering? Don't know if a Windows server can be part of 2 Clusters where you could have 1 Cluster and IP name assigned to Node1 and the other cluster IP Name assigned to Node 2, each being the failover for the other. With Exchange DAGs I could have Active Active, but DAGs are created in exchange and Drive letters had to be the same as well, but I could alternate where the primary DB was for a MailStore was.

[chayandutt]

Very well explained Kevin. A small question, when you say the availability groups are build on WSFC so is their a prerequisite on Windows side to build the Windows cluster before I can go to SQL server and start building the replicas? Thanks