May 8, 2020 at 3:02 pm
I have two secondary replica one in same location as primary and the second secondary replica will be located in DR location. So i am planing on backing up the databases on Primary and the one secondary replica located in the primary site. So the secondary replica in DR location i am not planing to do any database backups there . Do you see any issues without backups on the DR side? Thanks in Advance!
May 8, 2020 at 3:17 pm
In an event of disaster. If the fail-over is done to DR site and then DR will become primary, so in that case the backups are needed to be configured on DR right? Let me know if i am missing anything here?
May 8, 2020 at 3:49 pm
You will need jobs on the DR instance, disabled or checking for whether this is the primary replica before running.
May 11, 2020 at 4:46 pm
Thanks Steve. I have another question and outlined a 4-node cluster i am planning to configure. Node 1 - Primary
Node 2 - Secondary (HA) - synchronous, Node 3 - Secondary (DR) - asynchronous , Node 4 - Secondary (Reporting only,no sql backups since it will be used for select only the log will not grow with full recovery model) - asynchronous
The instance would fail over (set it up to be automatic) between nodes 1 & 2, manual fail over to node 3 - and never fail over to node 4.
I can offloading of reads to a secondary(Node2) and integrity checks on Node2, then that could be enabled on node 2 and maintained between those 2 nodes - with the understanding that reads will not be offloaded if one of those 2 nodes is offline or the system has been manually failed over to DR. The question is node2 will be repurposed later after we go live, do you think this would be a problem..since without testing that will put us in risk? What other problems do you think i can run into it? Thanks in advance!
June 2, 2020 at 7:57 pm
It's not quite clear what you mean. You are using some node numbers and number of nodes a little interchangably. Complex scenarios need testing and careful architecture. You also need to be sure you have good control over the connection string used by applications to ensure you can offload things.
For integrity checks, read this: https://www.brentozar.com/archive/2020/05/can-i-offload-dbcc-checkdb-to-another-server/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply