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

Why can't my PHP 5.4 webserver speak to my multi-subnet failover cluster using SQL Always On?

We've recently implemented a SQL Server 2012 Always On failover cluster. The go-live is in 2 weeks time and some concerning issues have come up. Previously we were dealing with servers in the same subnet, but we've since moved the servers to…
Jansky
  • 1,455
  • 1
  • 17
  • 33
2
votes
1 answer

SQL Server 2012 Create user from SQL query

I have a table of system users each of whom need a database user of their own that the system uses to access the DB(Not my idea..). The system has it's own login. This is creating a problem with the SQL AlwaysOn distributed server setup we're…
Jansky
  • 1,455
  • 1
  • 17
  • 33
1
vote
0 answers

How to avoid having to restart Delphi 32-bit application after it fails with a "memory allocation failure" on Database failover?

A Delphi 32-bit application fails with errors randomly "Error: the database connection was lost.An existing connection was forcibly closed by the remote host " or "Error Code: -2147024882 memory allocation failure" on Database failover. Application…
Sree
  • 11
  • 3
1
vote
0 answers

suspect database due to in-memory tables and resource governor(?)

Last night, both nodes on our Alwayson AG cluster went down at the same time. After a restart, only databases containing in-memory tables were marked as suspect. In the errorlog I see this message: (fragment) 2022-02-03 02:20:12.480 Resource…
Wilfred van Dijk
  • 89
  • 4
1
vote
1 answer

Kubernetes: Failed to join the instance 'mssql-secondary1' to the availability group 'fghyt'. (Microsoft.SqlServer.Management.HadrModel)

I have two node with names of mssql-primary and mssql-secondary1 configured with Kubernetes and mssql-2019 with always-on enabled. Everything works fine on both nodes but when I try to connect them to availability group I face below error: Failed to…
Payam Khaninejad
  • 7,692
  • 6
  • 45
  • 55
1
vote
0 answers

Do nodes of a Alwayson cluster impact each other?

I have an AlwaysOn group on two sql servers. Sql1 is the primary and SQL2 is the secondary replica. it's async mode and read-only allowed. My SQL2 (secondary replica) is only for reporting, so I set the failover level to 1 (which means no failover…
alma li
  • 11
  • 1
1
vote
1 answer

Is it possible to create SQL always on configuration in Windows 2016 cluster with no LB ip?

don´t know if this possible or not. client wants to create a Windows 2016 cluster with 2 different vms/nodes that are in Azure which are in different subscriptions and virtual networks. No shared storage the idea is to configure SQL always on…
Zucoa
  • 55
  • 8
1
vote
1 answer

SQL Synonym to a Always On Listener

I have 2 Microsoft SQL Server database servers DBServer1 and DBServer2 and 2 databases DB1 and DB2. Each of the databases is in a different availability group between the 2 servers. Therefore: Availability Group 1 (AG1) contains a DB1 in a cluster…
jorpilo
  • 46
  • 3
1
vote
1 answer

bringing back a TDE database in AlwaysOn gives an error

We recently added a new disk to our SQL Server 2016 AlwaysOn environment, configuration is equal on both nodes. I wanted to move some databases to this new disk. (all databases have TDE enabled, AlwaysOn is working fine). This is what I…
Wilfred van Dijk
  • 89
  • 4
1
vote
0 answers

Find out when the last failover occurred in AlwaysOn availability groups

I used below metioned query to find out if any failover happened in the last 30 minutes create table #errormsg(duration datetime,errornum int,dbmessage varchar(max)) DECLARE @tags3 VARCHAR(5000)SET @tags3 = (SELECT CAST( t.target_data AS XML…
Judi Durai
  • 11
  • 1
  • 3
1
vote
1 answer

Databases stuck in “Synchronized / In Recovery” mode after adding server to SQL Avaylability Group

I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network). Recently, I added another server to the AG, but…
Alberto Medina
  • 111
  • 1
  • 5
1
vote
0 answers

Targeting "AlwaysOn Availability Groups" database from the API

I'm designing an API (a WCF nettcp intranet webservice, not a public web api) that will target "AlwaysOn Availability Groups" database. The AlwaysOn is set in Synchronous-commit mode. It was suggested to me that I should use secondary replica for…
Ish Thomas
  • 2,270
  • 2
  • 27
  • 57
1
vote
0 answers

Storage pool configuration for SQL Server

We are in the middle of building a new SQL Server 2017 always-on cluster in Azure VM. The data disk layout of VM are as follows TempDb : 2 Azure Disk Read Cache TempDBLog : 1 Azure Disk No Cache UserDB : 3 Azure Disk…
user1716729
  • 387
  • 1
  • 6
  • 19
1
vote
2 answers

MSSQL case with raiserror statement error?

I am trying to check if the availability group is running on correct primary replica. I want to create a job that will fail if primary replica is not specific server. SELECT CASE WHEN primary_replica != @@SERVERNAME THEN (RAISERROR('Wrong…
Martina
  • 21
  • 1
1
vote
0 answers

Why does High Availability Group throw an error 35250?

I have a problem with creating a new high availability group in SQL Server. At the end of creating High Availability Group, I get an error 35250. I tried a lot of solution especially the solutions that are…
nima.taghidoost
  • 11
  • 5
1 2
3
…
13 14