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
2 answers

Moving Database from one availability Group to another sitting on different SQL Instance

We have Always on configured with Three Cluster Node ( 2 in same data center for HA and other one in different data center for DR). Each of the Node has three SQL instance on them. We have created one AG on per instance. Now we have situation ,…
Dheeraj
  • 11
  • 3
1
vote
2 answers

Unable to create availability group - tried all suggestions on the net

After several trials I keep getting this error message when setting new availablity group, please help me out. Create failed for Availability Group 'SQLAVG'. (Microsoft.SqlServer.Management.HadrModel) For help, click: …
HichemSeeSharp
  • 3,240
  • 2
  • 22
  • 44
1
vote
1 answer

If one database is down in an AlwaysOn availability group, will failover be initiated?

There is an AlwaysOn Primary replica configured with sync commit automatic failover secondary replica. If anyone of the databases of availability group is down/corrupted, will the failover process be initiated? Could anybody please help me with…
user1439891
  • 23
  • 1
  • 8
1
vote
1 answer

SQL Server Availability Groups and different collations

I have a unique challenge and I wanted to get other's opinions on this. I have a vendor database that is currently on SQL Server 2008 R2 and I need to migrate it off that server, for obvious reasons. I would like to move it to my SQL Server 2016…
Marcin Wilczek
  • 11
  • 3
1
vote
1 answer

Database from AlwaysOn availability group restored as normal database

I have a problem with a normal SQL database restored from a DB set in AlwaysOn high availability group in SQL Server 2017. I restored a copy of production db to a different server, to be used as QA test database, with a different name also -…
bzamfir
  • 4,698
  • 10
  • 54
  • 89
1
vote
1 answer

AWS Aurora High Availability High Level Diagram

I am trying to find high level system documentation how AWS Aurora High Availability works. Below is a diagram on how MSSQL AlwaysOn works. Our company is thinking of migrating from MSSQL to Amazon AuroraDB. Does Amazon AWS have high level system…
user8280126
1
vote
1 answer

snapshot isolation error using sp_setapprole on a read-only Availability Group replica

I am investigating SQL Server Always On Availability Groups and ran into a problem when setting an application role on the read-only replica database. What really irritates me is the behavior, and I don't know how to interpret the error message. All…
TRue
  • 11
  • 3
1
vote
1 answer

Azure Website Kudu HTMLLog Analysis shows Always On with high response time

We deployed our WebAPI as an azure website under the standard plan and have turned on Always On. After getting multiple memory and CPU alerts we decided on checking the logs via xyz.scm.azurewebsites.net. It seems Always ON has a high response time.…
Anshulee
  • 21
  • 1
  • 6
1
vote
0 answers

VDI_CLIENT_OTHER wait type in SQL Server 2016

After direct seeding on an on-prem SQL Server 2016, I still have 8 sessions (8 CPUs) permanently waiting on the VDI_CLIENT_OTHER wait type, for two days. It seems to be the result of direct seeding, as mentioned in this anwser. Azure SQL high wait…
rudi bruchez
  • 624
  • 3
  • 10
1
vote
1 answer

An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint

on one of my Always on configured server, I am seeing below error messages in the SQL logs. Does anyone have an idea what would be the issue? An error occurred in a SQL Server Service Broker/Database Mirroring transport connection endpoint - Alert…
Berk
  • 11
  • 1
  • 3
1
vote
1 answer

How to address availability groups in SQL 2016

How can i select information from a database which is in an availability group in SQL. Eg. I have 2 databases which are in 2 separate availability groups on the same server, I am in AG1 DB1 and trying to access a table in AG2 DB2. I know i can just…
James Whittaker
  • 13
  • 2
1
vote
1 answer

SQL Server AlwaysOn Availability

I have two server SQL Server 2016 and I want to implement the AlwaysOn Availabiliy. The first server is Read_Write The second server is Read_Only I configured an AlwaysOn Availability as folowing : CREATE AVAILABILITY GROUP ag WITH…
mchaari
  • 11
  • 2
1
vote
0 answers

Architecture - how to run SP on distributed databases and data sync to primary db

My project database is huge and there are multiple Stored Procedure jobs running based on schedule..Basically it is bottleneck for database performance. I want to distribute the load to different DB servers and merge data back to primary DB. My…
Arun
  • 11
  • 1
1
vote
1 answer

Whenever I kill a Select query on SQL Server Always On Cluster, it goes to ROLLBACK and hangs

Whenever I kill a Select query on SQL Server Always On Cluster, it goes to ROLLBACK and hangs. Do I need to stop the synchronous commit mode with the secondary and then kill the session and then start the sync ?
Vikash
  • 51
  • 3
1
vote
1 answer

TFS2013 to TFS2017 / Single SQL Server 2012 to SQL Server 2014 AAG

My current environment is on a single vm: TFS2013 SQL Server 2012 (dedicated instance, installed on the same vm) 1 project collection Reporting configured My migration target environment is: New VM containing TFS 2017 update 1 Existing SQL Server…
stephanejulien
  • 177
  • 13
1 2 3
…
13 14