Senior DBA Class High Availability and Disaster Recovery Part 2
Вставка
- Опубліковано 3 жов 2024
- You’re building a new SQL Server, and you need to protect it. You want to learn when it’s right to use clustering, AlwaysOn Availability Groups, virtualization, or storage replication. You don’t have an unlimited budget, either, so you need to learn how 2014-2016 licensing impacts these choices.
I just got my first job out of college as a Jr. Data Base Reliability Engineer; your content is extremely useful, thank you!
Great to hear!
Is it possible to have one server acting as a secondary replica for two primary replicas on AG?
Yes.
Great
Do we have any options to create a multi master setup in SQL server using AO feature.
Not with Always On, no.
@@BrentOzarUnlimited thank u for quick comment
can u pls suggest me high level solution using SQL server in which I can use two servers as masters to accepts writes and they sync internally like mutimaster in mysql
@@austinpeterv4870 Sure, go to BrentOzar.com and click Consulting at the top of the screen, and read how to hire me. Thanks, and speak with you soon!
Could you please let me know how should I configure step by step guide with cluster + log shipping both please.
That is pretty far beyond what I can teach you in a UA-cam comment.
@@TheBrentOzar Thanks a lot for replying me. If you don't mind or is it possible could you please make a video and upload. That should be great help for me. Once again thank you.
@@amitroy-cx2qb no, sorry.