Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
12 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
39 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
28 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
166 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
45 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
42 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
564 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 ...
4
votes
1answer
51 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 - ...
3
votes
1answer
47 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
6k 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
293 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
137 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
646 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
38 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
560 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
417 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
678 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
7k 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
15k 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
918 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 ...