Stack Overflow
Stack Overflow

Questions tagged [alwayson]

High-Availability and Disaster Recovery functionality, for SQL Server 2012 and later. A primary read/write database and up to 4 secondary database for reporting or disaster recover. There are several fail over and configuration options

196 questions
1
vote
1 answer

SQL Server 2014 Cluster Failover Instance, how to reconnect on failover?

I've setup an Windows Server Failover Cluster in a test environmnet, and installed a clustered SQL Server 2014 instance on it. The cluster has two nodes, and the network name is SQLINSTANCE. Now from small console application i have a simple loop…
Jeroen1984
  • 1,616
  • 1
  • 19
  • 32
1
vote
2 answers

Restoring a SQL Server 2012 database in high availability

I have a database which is in always-on high availability mode synchronized with another database on a different instance. How can I restore from a .bak file into the primary database using T-SQL? I'm new to high availability and I've been advised…
Stew
  • 305
  • 2
  • 5
  • 14
1
vote
1 answer

What is HADR SEEDING TEST database in High availability server, in sql server?

Our servers belongs to Always On Availability Group. In both node we could see a database like "HADR SEEDING TEST" has been created in our server. We don't know when was it created. How is it getting created and what is it? Will it make any…
user3480054
1
vote
1 answer

SQL Server 2012 AlwaysOn Availability Group, always connect to primary server

I have configured an AlwaysOn Availability Group without any problem. The database is mirrored synchronously and both SQL Server works correctly. I have created an Availavility Group Listener and configured the primary server to accept only…
Joorge Leal
  • 540
  • 1
  • 4
  • 9
1
vote
2 answers

SQL Server 2012 Always on has high logcapture wait type

From reading, I can see the Work_Queue wait can safely be ignored, but I don't find much about logcapture_wait. This is from BOL, "Waiting for log records to become available. Can occur either when waiting for new log records to be generated by…
Skeeboe
  • 21
  • 1
  • 3
1
vote
1 answer

Creating a c# application/windows service that runs once a day

Hi I need to create an application that runs once a day. The app can run at any time of the day right after the user login for the first time within the day. My question, what is the best approach to do this. Should I create a windows service or…
tora owen
  • 11
  • 1
0
votes
0 answers

SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)

We're running SQL Server 2017 Enterprise Edition on a pair of EC2 instances (we'll call them "P1" and "P3" here) in AWS. Each EC2 instance runs two instances of SQL Server (one for OLTP and one for OLAP). For maximum HA, but to keep costs…
sdaly
  • 1
  • 1
0
votes
0 answers

Transactional replication on dedicated server using AG Listener

I have dedicated server to setup transactional replication. i want to replicate 3 tables only Availability Database. The tricky part is, I want my transactional replication to continue automatically if automatic failover happen. Is there any way to…
zul nasir
  • 1
0
votes
0 answers

SQL Connection String Read Only Routing without ApplicationIntent=ReadOnly workaround

I am currently utilizing SQL Server with an Always On Available Group. In my AG, I have a primary active node and a secondary node used for read only queries. To access the secondary node, we pass ApplicationIntent=ReadOnly as part of the…
Jon
  • 2,129
  • 7
  • 23
  • 31
0
votes
0 answers

Why does MultiSubnetFailover keep trying to connect to the inactive IP?

I am trying to use MultiSubnetFailover and it doesn't seem to be able to decide which IP to use. Setup: Client Connection String: MultiSubnetFailover=True Server: Get-ClusterResource -Cluster -Name | Set-ClusterParameter -Name…
Jacque
  • 1
  • 1
0
votes
0 answers

How is data loss possible if we lose primary in Read-Scale (clusterless) AG Sync-commit configuration (SQL Server AlwayOn)?

Microsoft documentation for Read-Scale (clusterless) failover: "If the primary replica is not available and can't immediately be recovered, then you need to force a failover to the secondary replica with data…
qqq
  • 1
  • 1
0
votes
0 answers

SQL Server 2022 Contained AlwaysOn Group - reuse system databases

The following issues I've come across and wanted to let the community know, just incase. So I have a lab environment, 4 nodes , SQL Server 2022 Enterprise, CU3. For some reason, if you create the AG group without reusing system databases, the…
Saruman
  • 21
  • 2
0
votes
0 answers

Get Windows Server Failover Cluster node name and state (Primary or Secondary) with T-SQL

I have multiple availability groups on my SQL Server instance, as its edition is Standard. I want to fail-over all the AG`s from primary node of WSFC, if one AG was failed over. To do that I need to check in my scheduled job if I'm currently on the…
yoma
  • 359
  • 1
  • 7
0
votes
0 answers

SQL Server - Statistics MetaData Deadlock

We have an Always On architecture of 4 servers. 2 servers are in availability mode synchronous commit. let's call them A and B. and 2 servers are in availability mode asynchronous commit. let's call them C and D. In our database,…
Tom
  • 3
  • 3
0
votes
0 answers

Connection to Availability Group Listener gives a 'Transport Level' Error in SSMS when I shut down Primary

I have a Node1\INST1 SQL Server instance which is the Primary and a Node2\Inst2 which is the Secondary in the High Availability Group. Both shows 'Synchronized' as the status, and both show 'No Data Loss'. I have also configured the Failover…
hillcountry99
  • 37
  • 6
1 2 3
…
13 14