SQL Server High Availability and Disaster Recovery overview

Рет қаралды 38,445

5 жыл бұрын

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

Пікірлер: 49

@lordmunni 4 жыл бұрын

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

@Kevin3NF 4 жыл бұрын

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 2 жыл бұрын

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

@Kevin3NF 2 жыл бұрын

Glad it helped :)

@krishtheindian 4 жыл бұрын

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

@Kelmebrahtu 3 жыл бұрын

thank you Kevin, very well explained .

@TravellerPande 4 жыл бұрын

Thanks Kevin! Very informative video. Learnt a lot!

@Kevin3NF 4 жыл бұрын

Glad it was helpful!

@whymizan 3 жыл бұрын

amazing no word salute boss

@rachpalsingh3498 4 жыл бұрын

Superb. Thanks for sharing.

@CosmeJunior 3 жыл бұрын

Amazing Video, congratulations Kevin

@Kevin3NF 3 жыл бұрын

Thank you very much!

@drpglobalsolutionsllc6926 3 жыл бұрын

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

@Kevin3NF 3 жыл бұрын

great to hear! Thanks for the feedback

@Safe.Tech22 3 жыл бұрын

great details, thank you

@nickrowan Жыл бұрын

Another super useful video!

@Kevin3NF Жыл бұрын

Glad you think so!

@raghuvnr 3 жыл бұрын

Thank You, Kevin, you have simplifed!

@Kevin3NF 3 жыл бұрын

You're welcome!

@vishalpechetty Жыл бұрын

Thank you so much Kevin! Very well explained

@Kevin3NF Жыл бұрын

Glad it was helpful!

@TheKraphtOfSkill 3 жыл бұрын

Very helpful explanation. Thank you Kevin.

@Kevin3NF 3 жыл бұрын

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

@TheKraphtOfSkill 3 жыл бұрын

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

@eyerusalemful Жыл бұрын

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

@Kevin3NF Жыл бұрын

Glad it helped!

@davidshen3237 Жыл бұрын

thanks for the explanation, very useful.

@Kevin3NF Жыл бұрын

Glad you liked it

@kukawkap 3 жыл бұрын

Great video !

@Kevin3NF 3 жыл бұрын

Thanks!

@solsh6467 5 жыл бұрын

Great!

@aryalakshmi3221 2 жыл бұрын

Best one

@jorgesmitley3797 4 жыл бұрын

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.

@chayandutt3797 3 жыл бұрын

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 3 жыл бұрын

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

@tom110111 4 жыл бұрын

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 4 жыл бұрын

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

@tusharjain8572 3 жыл бұрын

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

@Kevin3NF 3 жыл бұрын

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

@DLPTonyATL 2 жыл бұрын

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 2 жыл бұрын

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 2 жыл бұрын

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