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

Azure alwaysOn is not loading MEAN app on server restart

I have a MEAN stack application hosted on Azure with the alwaysOn setting, but this doesn't seem to start the node process without a manual http call. This is fine but not ideal for front end tasks but killer for a daily task that needs to be…
Tom Lightbody
  • 69
  • 1
  • 5
0
votes
1 answer

Creating listeners with SQL Server AlwaysOn suddenly stopped working

Problem: I created 10 AlwaysOn Availability Groups with SQL Server without a problem. Suddenly, it stopped worked and I kept getting this ONLY on the "create the listener" part: Msg 19471, Level 16, State 0, Line 9 The WSFC cluster could not bring…
stackonfire
  • 1,525
  • 4
  • 17
  • 23
0
votes
1 answer

In SQL Server Always ON configuration - will Transaction Log backup to Nul breaks Always On configuration?

Imagine we have two nodes participating in SQL 2012 AO. This is a test instance. During one of the index rebuild operation the log was grown up really big (250 GB). We are unable to back it up due to space constraint. What if we backup the Tlog to…
user3270509
  • 1
  • 1
0
votes
0 answers

How to manage Data Latency on read-only AlwaysOn SQL Databases?

We have several read-only nodes in our AlwaysOn cluster, which are set to use Synchronous-commit mode, which ensures that the logs are updated on the read-only nodes before any update statements complete. Even with this option, if we query a…
Eric
  • 2,120
  • 1
  • 17
  • 34
0
votes
2 answers

Are Hekaton transaction logs larger than usual in a failover cluster?

In a meeting a few days ago someone said that "using Hekaton increases the size of the transaction logs which increases the time to fail over" while describing the challenges of an AlwaysOn SQL cluster that uses Hekaton in-memory tables. I'm not a…
AgentExe
  • 17
  • 4
0
votes
1 answer

SQL Server 2012 AlwaysOn

I am trying to access SQL Server 2012 db always on listener (secondary replica, with ApplicationIntent=ReadOnly parameter) with a SQL Server user authentication through untrusted domain and I am getting error: This is usually a temporary error…
A.T.
  • 1
  • 2
0
votes
3 answers

AlwaysOn Availability Groups Support msdtc

I have to work with AlwaysOn Availability Groups with msdtc.It's not work for me.after searching i read Cross-Database Transactions Not Supported For Database Mirroring or AlwaysOn Availability Groups (SQL Server).My question is AlwaysOn…
user1968030
0
votes
1 answer

add node fails w/ Azure WSFC 2012 for SQL2012 AlwaysOn Availability Grps

Adding node fails Windows Server 2012 Failover Cluster for AlwaysOn Availability Groups in all AZURE, is leaving an apparent phantom VM node. How can I cleanup up? Server property for target server VM is flagged as "clustered", but is not. There…
RickWillemain
  • 1
  • 3
0
votes
2 answers

Spread workload with always on high availability groups

I am wondering if it is possible to split up a very large query to have parts of it done on the secondary read only servers, or If this feature only allows me to run separate queries or scripts on the secondary servers. I would also like to know if…
user235289
  • 63
  • 7
0
votes
2 answers

Connecting to a SQL Server 2012 AlwaysOn Group Listener with MultiSubnetFailover results in a Timeout

We're having a strange issue where our developers are not able to connect to the AlwaysOn Availability Group Listener when MultiSubnetFailover is set to true. However, the clients can connect when attempting to connect directly to the primary node…
Bryan McLemore
  • 6,438
  • 1
  • 26
  • 30
-1
votes
1 answer

Microsoft SQL Server 2019 on linux always on pcs status error

This is a newly deployed environment and an error has been reported after executing the following command pcs resource create sqlag ocf:mssql:ag ag_name=sqlag master notify=true pcs resource create AVGListener ocf:heartbeat:IPaddr2…
Jerry Chen
  • 1
-1
votes
1 answer

SQL Server :: Replication Distribution Agent never ending

I'm running SQL Server 2019 Always ON Availability Group with an asynchronous replication. I use a free tool called IDERA SQL Check and I have spotted the SPID 69 which program name is Replication Distribution Agent. It's always there, staring at me…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
-1
votes
3 answers

AlwaysOn Failover, secondary node jobs fails

When testing the failover functionality, the secondary node is unable to run any jobs accessing a TDE database failing with the following error Please create a master key in the database or open the master key in the session before performing this…
jlj
  • 75
  • 1
  • 10
-1
votes
1 answer

TFS 2017 Upgrade SQL Server Always on

When upgrading TFS 2015.1 to TFS 2017.2 do I leave SQL Server 2014 Always On turned on? We have TFS 2015.1 running on SQL Server 2014 with Always on and everything is working fine. Upgrading to TFS 2017.2 and assume I just leave the database server…
George Altenbaugh
  • 3
  • 1
-1
votes
1 answer

what to check if automatic failover does not work on always on availability group?

on one of my environment automatic failover does not work. what things i need to check, please help me on this?
Yogi
  • 49
  • 1
  • 7
1 2 3
…
13
14