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
0
votes
1 answer

Proper way of restarting SQL Node with Availability Groups and Replication

I have active/active cluster with availability groups in async mode on both parts of that cluster, so each node is being used as a Primary and a Secondary replica at the same time. Also we have a Transactional Replication from Node1 to Node2.…
Andreas
  • 1
  • 2
0
votes
2 answers

Can not access SQL Server by using Listerner Address with readonly

I have two instance of SQL Server running as AlwaysOn primary - replica. Now I want to setup connect reading database in replica. I have just setup my SQL Servers following this instruction:…
Dương Quang Thọ
  • 213
  • 4
  • 15
0
votes
1 answer

SQL AG Secondary as a Primary of a 2nd group

Wanted to get your thoughts on trying to load balance my 2 node Always On AG (SQL 2016). Currently I have x Databases in one group with one listener and 2 nodes (primary/secondary). I want to try to utilize the secondary so that it is not just…
Marcin Wilczek
  • 11
  • 3
0
votes
1 answer

Database is taking forever to join the HA Group on SQl Server 2012

We have 2 nodes in our environment and due to a failover that was caused by network connectivity issue, our databases weren't synchronizing on our secondary node. I tried resuming/starting data movement and that didn't help. I have tried several…
mahabuba.mu
  • 1
  • 1
0
votes
0 answers

AG listener Issue

I created AG group on SQL Server 2016 SP1 CU8 on windows 2016 core edition. However, I am unable to connect using AG Listener name. what could be the possible reasons? I can ping and telnet static IP and Listener DNS name from my local machine even…
ReddyEsh
  • 1
  • 3
0
votes
1 answer

Change sql server instance name to AG listener for sharepoint

Recently our sharepoint admin deployed new farm using Sql Server instance name without using alias. Now i want to change the sql instance name to SQL Listener in sharepoint farm for high availability. Is it possible? How to go about it? What could…
Irfan Ahmed
  • 1
  • 2
0
votes
1 answer

What is the purpose of static IPs for SQL HAG listener?

Can somebody answer following questions. I have 2 Azure VMs with HAG setup but no HAG listeners are setup. The reason being I'm confused where those static IPs are supposed to come from and if they are needed in a first place. Questions: Why do I…
Gregory Suvalian
  • 3,566
  • 7
  • 37
  • 66
0
votes
0 answers

AlwaysOn Geo Dispersed Automatic Failover

I'm looking to implement a "not quite" hub and spoke type architecture using AlwaysOn and wondered how the cluster quorum might play into this scenario if a remote site can't connect to the hub where we setup a file share witness or the other nodes…
GoldenDBA
  • 46
  • 3
0
votes
0 answers

Flyway on AlwaysOn

We are trying to use the Flyway API to create an SQL Job on both MSSQL AlwaysOn replicas. most of the migration should execute against the primary replica. But, how can we execute the sql script file to create the job on both replicas?
yuval lior
  • 1
0
votes
0 answers

MS SQL Always On is on UNC Path

Microsoft writes that you can use Always On on the UNC path, but does not explain. How to make one replica to \server1\data1, and the second to \server2\data2
Nikolay
  • 1
0
votes
0 answers

sql server alwayson secondary sync database delay

I have a sqlserver 2016 always-on with one primary and one secondary database. However I got nothing when I query the secondary database right after I get confirmation from primary database that insert is done. So I think this is because primary db…
Long
  • 1
  • 1
  • 3
0
votes
1 answer

Can I use active secondary replica server for both failover and reporting/backups

I have my WSFC setup with three nodes in my Availability Group. One for DR and one primary and the other active secondary. the secondary will be used to failover should my primary server fail. My question is can I also use the secondary to do…
hashguard
  • 403
  • 4
  • 22
0
votes
0 answers

SQL unable to resume data movement after manual failover

We have a 3 node availability group, PRIMARY, a synchronized none readable replica and a async readable replica. We are currently doing an in place upgrade to 2016, both secondaries have been upgraded and patched so I am manually failing over the…
Yen
  • 23
  • 1
  • 4
0
votes
2 answers

SQL Server Log Files growing rapidly

We have SQL Server 2012 (on Windows Server 2012 R2) and a database configured for AlwaysON (01-03) and we take full backups once a day and log backups every 5 minutes. The size of the database is 288 GB (mdf - 88GB, ndf - 110 GB, ldf - 84 GB). There…
user112359
  • 11
  • 2
  • 5
0
votes
2 answers

AlwaysOn Availability listener access issue

I'm using SQL Server 2014 Enterprise edition. I have created an alwaysOn Availability group on a named instance and configured a listener to it. When I try to access the listener from SQL Server Management Studio it logs to the default instance. I…
DB_AM
  • 13
  • 4
1 2 3
…
13 14