Question : Firstly, forgive my poor question title. I couldn’t think of the best way to summarise this. Essentially I’m […]
Tag: disaster-recovery
Why do I need witness in WSFC with two nodes?
Question : I have Windows Server 2019 and SQL Server 2019 running in both nodes of my cluster. In my […]
Transaction log uses (not backups of transaction logs)
Question : Working with an interesting scenario that quite frankly, I have not had the time to test, and would […]
Standby archive deletion
Question : I have a primary database with a standby in data guard configuration running in a RHEL host. Thing […]
Not receiving archivelogs from production to remote side [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Tip of the iceberg – the question […]
AAG expansion between datacenters
Question : We have a 2 node AAG setup in the DC data center, and due to an application requirement, […]
File Share Witness location
Question : We have a 4 node availability group with 3 node on the primary data center and one node […]
Master/Slave without populating tables
Question : So I have some Zabbix instances which are using MySQL for their backends. What I would like to […]
Business Continuity Plan — How can I connect to DR Server if PROD site is completely Down
Question : I have two servers in one DataCenterA (PRODUCTION SQL SERVERS AOAGs) and one server in another DatacenterB (DR […]
Availability groups across sites: what happens if severs can’t contact each other but both still can reach file share witness?
Question : I’m currently planning a new SQL Server 2019 Enterprise Edition setup with HA/DR, possibly with availability groups. Let […]