SQL Server High Availability and Disaster Recovery overview

[@richardwaldron1684]

Excellent video. I've just watch two of your SQL tutorials on Pluralsight which were excellent too, your presentation style is very clear and effective, plus it's backed up (pun intended) by your real-world DBA experience. I'm glad to see you're also helping and teaching people on KZbin too. Thanks for posting

[@PazGorbiz]

Great job! Exactly the level of info about MSSQL HA/DR I was looking for right now. :)

[@Kevin3NF]

Glad it was helpful!

[@lordmunni]

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

[@Kevin3NF]

That's great to hear! thanks for the feedback. I recently did the written version of this video here is he wants something to look at in text: dallasdbas.com/sql-server-hadr-overview/

[@14dixit]

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

[@Kevin3NF]

Glad it helped :)

[@krishtheindian]

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

[@vishalpechetty]

Thank you so much Kevin! Very well explained

[@Kevin3NF]

Glad it was helpful!

[@Kelmebrahtu]

thank you Kevin, very well explained .

[@nickrowan]

Another super useful video!

[@Kevin3NF]

Glad you think so!

[@whymizan]

amazing no word salute boss

[@TravellerPande]

Thanks Kevin! Very informative video. Learnt a lot!

[@Kevin3NF]

Glad it was helpful!

[@davidshen3237]

thanks for the explanation, very useful.

[@raghuvnr]

Thank You, Kevin, you have simplifed!

[@Kevin3NF]

You're welcome!

[@CosmeJunior]

Amazing Video, congratulations Kevin

[@Kevin3NF]

Thank you very much!

[@TheKraphtOfSkill]

Very helpful explanation. Thank you Kevin.

[@Kevin3NF]

Glad it was helpful! Are you looking to implement or enhance your HADR?

[@TheKraphtOfSkill]

@@Kevin3NF another implemented our existing systems. I recently took on the responsibility of understanding what they put together, what we have and if we’re applying best practices for our business needs.

[@tusharjain8572]

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

[@Kevin3NF]

Two points: Mirroring is deprecated. TDE is file level (MDF/NDF/LDF) at rest...not column level. You can set up TDE on an Availability Group, which is very similar to Mirroring. I've never tried mirroring/TDE together

[@Signofnothing]

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

[@Kevin3NF]

Log shipping is free in the product, but is just automated Backup/Copy/Restore

[@aryalakshmi196]

Best one

[@drpglobal]

Outstandingly great!!!!!! Exactly what I needed to train some people on.

[@Kevin3NF]

great to hear! Thanks for the feedback

[@eyerusalemful]

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

[@Kevin3NF]

Glad it helped!

[@rachpalsingh3498]

Superb. Thanks for sharing.

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

[@Kevin3NF]

I don't have any article or video, but I do have a client with 2 on-prem VMs in data center, a 3rd VM in a different DC and an AWS VM at the 4th replica. So it works, but I didn't do the setup, nor have been part of testing failover.

[@DLPTonyATL]

@@Kevin3NF Cool beans…I’m thinking if I setup a VPN between us and the entity with AWS, it’ll move the ball closer. I’m glad to know it can work! Thank you.

[@chayandutt3797]

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

[@Kevin3NF]

Clusterless Availability Groups are available starting (I think) in SQL 2017, but that will only get you Disaster Recovery, not High Availability.. Double-check me on that :)

[@jorgesmitley3797]

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.

[@tom110111]

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)?

[@Kevin3NF]

That is certainly one of many possible configs. I tend to run my backups (ola) closer to the source...synchronous nodes. There are some restrictions on Differential backups...but I'lll leave that Googling to you :)

[@Safe.Tech22]

great details, thank you

[@kukawkap]

Great video !

[@Kevin3NF]

Thanks!

[@gajendra-419]

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

[@Kevin3NF]

Do you mean Availability Groups or SQL Failover Cluster Install? I can send links to either, but cannot get even close in a 10-15 minute video.

[@cmizg3716]

@@Kevin3NF expecting your link. Nice to search you and it is a real fantastic video

[@solsh6467]

Great!

[@majedsedky6084]

hi can you share the ppt

[@Kevin3NF]

No, sorry. That is a copyrighted work of Dallas DBAs LLC.