SQL Server High Availability and Disaster Recovery overview
Vložit
- čas přidán 5. 07. 2024
- 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 - Věda a technologie
This video fits absolutely exactly what I needed to understand so I can explain it to my boss.
Thank you very much!
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/
Really good explanation ! Clears some basic doubts when learning about Availability Groups and Disaster Recovery.
Glad it helped :)
Up to the point and clear!! Thanks much!!
thank you Kevin, very well explained .
Thanks Kevin! Very informative video. Learnt a lot!
Glad it was helpful!
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.
amazing no word salute boss
Outstandingly great!!!!!! Exactly what I needed to train some people on.
great to hear! Thanks for the feedback
Superb. Thanks for sharing.
Amazing Video, congratulations Kevin
Thank you very much!
great details, thank you
Thank You, Kevin, you have simplifed!
You're welcome!
Thank you so much Kevin! Very well explained
Glad it was helpful!
Another super useful video!
Glad you think so!
Very helpful explanation. Thank you Kevin.
Glad it was helpful! Are you looking to implement or enhance your HADR?
@@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.
thanks for the explanation, very useful.
Glad you liked it
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
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 :)
Thank you very much,It was so perfect and what I need to u derstand
Glad it helped!
Great!
Great video !
Thanks!
Thanks Kevin. This give goods insight.
Do mirroring also automatically handle column level TDE(encryption)?
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
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)?
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 :)
Best one
Great presentation, just for curiousty, is there a tech as cheap as LS and if it is going ti continue to operate
Log shipping is free in the product, but is just automated Backup/Copy/Restore
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?
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.
@@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.
hi can you share step by step configuration to HA with failover(wsfc)
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.
@@Kevin3NF expecting your link. Nice to search you and it is a real fantastic video
hi can you share the ppt
No, sorry. That is a copyrighted work of Dallas DBAs LLC.