Questions tagged [hadr]

HA/DR refers to High Availability / Disaster Recovery, which is typically a suite of technologies provided by a database engine vendor with the aim of increasing availability of data stored in the database, and providing a fast method of return-to-service after a disaster.

Filter by
Sorted by
Tagged with
2
votes
1answer
24 views

What is the difference between sys.dm_hadr_ tables and sys.availability_groups / sys.availability_replicas?

Browsing around some sys tables, I see: sys.dm_hadr_availability_replica_cluster_nodes.group_name = sys.availability_groups.name and sys.dm_hadr_availability_replica_cluster_nodes....
1
vote
1answer
36 views

How To Prevent Live Servers From Detecting a Forced Failover?

We are using an AlwaysOn Availability Group in SQL 2017 on Windows Server 2016 which consists of two servers on our primary site and one DR server on a remote site. We recently did an internal IT DR ...
0
votes
1answer
120 views

MultiSubnet Failover with RegisterAllProvidersIP 1

I am using a 2 node SQL AG (2014 EE) (each on a different subnet) and the Listener is configured with 2 Static IPs. The client application uses SQL Native Client 11.4. My understanding is that this ...
1
vote
2answers
189 views

Stored Procedure on a read-only AlwaysOn Availability Group replica

We have a read-only reporting server that is part of the AlwaysOn availability group. Our developer wants to create some stored procedures. My question is where should the stored procedure be ...
1
vote
1answer
132 views

DBCC check on Always On Secondary Replica

What is the best way to schedule DBCC check on all the nodes in Always On availability group. Can we just schedule the same job on all the nodes at the same time including all the secondaries. In my ...
1
vote
1answer
174 views

Listener IP not changing after failover

We have a multi-subnet AlwaysOn availability group. There are 2 subnets and those are listed on the cluster and also the listener. Whenever I fail over and ping by the listener name it still shows ...
0
votes
1answer
75 views

File Share Witness with 4 Node Cluster

I am building a cluster of 4 nodes along with a file share witness. Every month due to server updates the server that holds the file share will need to be rebooted. My question is while the file ...
0
votes
1answer
23 views

Domain Controller on Multi Subnet Always on Availability Group

This is will be my first big project. We have 4 Replica Always on availability group with 3 Replica on site and another replica offsite (different subnet) the File share witness will be placed on ...
0
votes
1answer
37 views

What happens when the same application from different server tries to connect to the always on primary server

In our environment we have an always on availability group and the reporting server is acting as a secondary replica with Synchronous Mode, manual failover. XSLT report editor that is a vendor ...
0
votes
1answer
120 views

Listener Port 1433 for Always on Availability Group

In our Availability group I have a reporting server where report writers will connect directly and also crystal reports will be used, If the listener port is 1433 and the clients also gets connected ...
0
votes
1answer
60 views

Read only replica part of always on availability group for Reporting

As a DBA I would like to include a read only replica into the always on availability group. XSLT / Crystal Reports will only be used. Please see below 1) Primary Replica (Same Data center) ...
1
vote
1answer
168 views

Cluster IP's under Access Point for Administering the Cluster

When adding the cluster IPs under Access Point for Administering the Cluster, do we only include IPs for the public subnets, or do we also need to include an IP for the private subnet(s)? This ...
0
votes
1answer
130 views

Automatic fail over in Always on availability group with 3 Node in synchronous mode and 1 Node in Asynchronous Mode

I am laying out a plan where there will be 3 Node on site with automatic fail over with synchronous mode and 1 remote replica with asynchronous mode. My question is if the primary goes down which node ...
1
vote
1answer
282 views

When does Log shipping restore job mark itself to completion in standby mode

I am editing my previous question to be more precise as i am still unable to get the logic behind the log shipping restore job. May be there is something i am missing to explain but will try my best. ...
2
votes
2answers
59 views

Making Production database as Publisher and Distributor for Snasphot Replication

In our environment we are using Log Shipping as DR. Our primary database is a clustered instance. My requirement is to set up a snapshot replication for reporting purposes. My plan is as follows: ...
1
vote
1answer
126 views

Cluster Validation on Remote Node

I have a 3 Node always availability group: 2 Nodes are In house – Synchronous Mode. 1 Node is remote - Asynchronous Mode. Every now and then the Remote Node loses connectivity and goes offline ...
2
votes
4answers
2k views

Log Shipping or Always on as DR for SQL Failover CLuster

Which is easier to maintain as Disaster Recovery on a remote site for a 2-node SQL Server Cluster Log Shipping Single Instance of Always on Availability Group Instance. Any suggestion will be ...
3
votes
1answer
57 views

Does SQL Server route connections to a secondary replica which has commit mode as synchronous in case of an AG with multiple secondary nodes?

If I have an AG with 4 different nodes as below: Primary Node Secondary Node 1 - Asynchronous Commit - Read Only Yes Secondary Node 2 - Synchronous Commit - Read Only No Secondary Node 3 - ...
2
votes
1answer
55 views

A question about multisite Always On design

Your advice on Always On design please... Imagine a scenario where you have 2 datacentres in different countries. You want to be able to run at full capacity in either datacentre. in each datacentre ...
4
votes
1answer
7k views

Are “Always On Failover Cluster Instances” and “SQL Server Failover Clustering” the same thing?

I'm reading documentations of SQL Server. On this page at https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/windows-server-failover-clustering-wsfc-with-sql-server, it says: ...
1
vote
2answers
384 views

AlwaysOn - Problem with adding secondary replicas

I installed AlwaysOn on my laptop (testlab) with three VMs, of which one is a domain controller and two are hosting SQL Server instances (planned to be one primary and one secondary replica). ...
1
vote
3answers
167 views

Problem Configuring Log Shipping for DR Server

Problem Statement - I want to configure DR site in SQL Server 2012 with the existing backups. The backup scenario is as below. FULL – on every Sunday, DIFF – daily except Sunday, LOG – every 15 ...
1
vote
1answer
784 views

Change column from NOT LOGGED to LOGGED

I have a database DAT1 running on DB2 version 10.5. I want to enable logging for all CLOB and BLOB columns of my table TAB1. The table was initially created with those columns as NOT LOGGED but now I ...
0
votes
1answer
41 views

HADR procedures

We are thinking of a SQL Server 2014 + Windows Server 2012 configuration for a HADR scenario. My questions are: on a HA scenario, how does the primary server get updated once it is again available ? ...
9
votes
1answer
743 views

HADR high worker thread usage

Why would an availability group's number of worker threads in an HADR pool increase well beyond minimum usage of "typically, there are 3–10 shared threads" per replica? In one case we've observed ...
1
vote
1answer
492 views

SQL Availability Group restore database to standalone server

Running: SQL Server 2012, Windows Server 2008 R2 I want to test a backup by restoring onto an isolated server. The backup was taken from an Availability Group (HADR) configuration, but the target ...
2
votes
0answers
779 views

SQL Server Management Studio with Multi subnet HADR cluster

We are starting to deploy Multi-Subnet HADR AlwaysOn clusters for our environment. Using MultiSubnetFailover=True in application connection strings works. However, SSMS connections require manual ...
1
vote
1answer
8k views

How to Start DB2 10.5 HADR on the Standby Database

I am trying to set up HADR to run on my DB2 10.5 DB2 servers. I believe I have followed the steps correctly, but I'm getting the following error: [db2insh1@rslvm20 OneView]$ db2 restore database ...
5
votes
4answers
16k views

Removing Databases in Recovery Pending Status after AG group was removed

I have removed a High Availability Group, disabled the option in sql configuration manager and restarted and I have also removed the Failover cluster components from windows and restarted. ...
3
votes
2answers
960 views

IBM DB2 v9.7 HADR TSA failure on the standby server

I have an environment here where I have 2 servers running DB2. One is the primary and the other one is standby. They replicate with HADR and failover is made automatically by TSA. What's the default ...