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

SQL Always On Secondary replica limitations

Can you please clarify how many secondary replica nodes can be in synchronous commit mode in 2012/2014/2016. I know that we can have 4 and 8 secondary replica in 2014 & 2016 respectively. Please let me know the limitation on synchronous committ…
SQLDoctor
  • 343
  • 7
  • 16
0
votes
0 answers

DSE 6.7 Alwayson SQL

I have enabed alwayson-SQL through the dse.yaml file. When I am typing the following command "dse client-tool alwayson-sql start" i get the followig errors from system.log WARN 2019-12-26 12:22:33,606 org.apache.spark.util.Utils: Your hostname,…
Siguy12
  • 1
  • 1
0
votes
0 answers

How to determine the SQL Server causing an exception in Always On cluster

I have a C# app that connects to an 8 node SQL Server Always-On cluster. We are using the ApplicationIntent=ReadOnly parameter and the Listener IP in the connection string to allow connections to all servers for queries. We are logging, within the…
JSD
  • 1
  • 1
0
votes
1 answer

SetSPN for Always-On enabled server

We have a three node cluster setup for AON. We are receving the below error in the log. The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/servername.domain:port ] for the SQL Server service.…
SQLDoctor
  • 343
  • 7
  • 16
0
votes
1 answer

Cannot login using listener name on secondary server after failover

i am not able to connect using AG listener name after fail-over to secondary server. SSMS gives error 18456 ( login failed for user ''). I have tested following scenarios: - 1st server is working as expected with listener. Problem occurs when second…
Irfan Ahmed
  • 1
  • 2
0
votes
1 answer

SQL Server - AlwaysOn Redirect Writes with Readable Secondary Enabled

I have AlwaysOn setup among two nodes running 2016 enterprise edition. The option Readable Secondary is set to Read-intent only. On using the parameter ApplicationIntent=ReadOnly it is always redirected to secondary for read operations. But our…
Yashwanth Aluru
  • 1,125
  • 6
  • 21
  • 28
0
votes
1 answer

How to change secondary DB to primary when use Sql Server HA alwayson and primary pc was disconnected

I am investigating trouble shooting in always-on environment of two computers. If the primary's network was disconnect(not shutdown), the secondary's DB is unavailable. It seems that the cluster is unable to determine the failure by quorum…
Jerrey
  • 1
  • 1
0
votes
1 answer

Moving files to new SQL Server Version / Instance in Always On

I have SQL Server 2014 with Always On. I installed SQL Server 2017 in the same server and I want to move the Database from SQL Server 2014 to SQL Server 2017. In every replica, I have their own files (.mdf and .ldf). In SQL Server 2014, In the…
Francisco G
  • 1,434
  • 2
  • 14
  • 22
0
votes
1 answer

Azure WebJob sudden shutdown while processing

I have a continuous Azure WebJob, that is set to 'Always On'. This WebJob is supposed to handle new messages being added to a storage queue. I'm wondering what if for some reason the WebJob has stopped working while it was processing a queue…
Akram Qalalwa
  • 103
  • 11
0
votes
1 answer

AlwaysOn Availability Groups Storage

I am looking at implementing AlwaysOn Availability Groups for my production environment. I have 2 servers. My goal is to have 1 as the live database and the other available in case the primary goes down. I'm trying to figure out if both servers…
user2780362
  • 67
  • 9
0
votes
0 answers

Script to remove multiple databases from HA

Problem Statement : We two database server (SQL01 & SQL02). Lets assume SQL01 is my primary server and SQL02 is secondary server. My primary database server contain around 100 databases and SQL02 is connected to SQL01 as the fail over server. For…
Jyoti Prakash Mallick
  • 2,119
  • 3
  • 21
  • 38
0
votes
1 answer

Main metrics to monitor with Always On

There are some metrics to monitor for performance with Always On: redo rate, received rate, send queue,..etc What are the main ones that we should usually monitor and keep attention to?
Lika
  • 17
  • 5
0
votes
2 answers

Provision SQL Always on in Azure VMs with external access

We are setting up SQL Always On in Azure VM (IAAS). We followed the steps given in Configure Always On Availability Group in Azure VM manually and the setup is working fine. Since the setup is using the internal load balancer, the listener is…
amit_g
  • 30,880
  • 8
  • 61
  • 118
0
votes
1 answer

SQL Database in Asynchronous AO relication - Log file not shrining after backup

I have a database whose log file size is 527GB, showing almost 100% use. The DB is in AO Asynchronous replication with another SQL server. DB is in Full backup mode, and Log backup is happening every hour. I tried to shrink log file, it didn't work,…
arifr
  • 61
  • 2
  • 9
0
votes
1 answer

SQL Server AlwaysOn Availability Groups/Mirroring RPO and Availability

Is there any document clearly telling MAX RPO and Availability attained through SQL Server AlwaysOn Availability Groups/ Mirroring? i.e. 1 min and 99.99% like that?
Jaish Mathews
  • 766
  • 1
  • 9
  • 25
1 2 3
…
13 14