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

SQL AlwaysOn secondary replica down

One of my replica in the alwayson is down for several minutes. My question is, for how long the secondary replica can be down ? can I get it from dmv table or somewhere else ? 10X
itzik Paz
  • 403
  • 5
  • 14
1
vote
1 answer

read-only intent in high availability replicas SQL server 2014

We have 2 sql server replicas in Always On cluster and when we tested for performance issues we saw that only the primary is working (read and write). the primary is set to read-write and the secondary is set to read only intent, we want to send the…
sergey efimov
  • 11
  • 2
1
vote
1 answer

Unable to ping Windows Cluster's IP and unable to connect listener IP

I'm using windows server 2012R2, recently I created a WSFC with 2nodes,Both nodes are in same subnet and assigned a static IP for the cluster. But I can ping the cluster's IP only from the current node, even the node2 and other servers which are in…
TheDataGuy
  • 2,712
  • 6
  • 37
  • 89
1
vote
0 answers

Is there any way to connect Oracle DBLink with SQL Server AAG Read Intent (Read Only)

There are two database server, the first using oracle database and the second using SQL Server database. We are created Database Link (DBLink) from oracle to SQL Server to read the data for reporting purpose, and the SQL Server using replication to…
Kharis
  • 69
  • 1
  • 7
1
vote
1 answer

How do you identify if sql server instance is an 'always on' replica?

is there a way to interrogate a sql server instance or db to identify that it is an alwayson replica?
Chris Hayes
  • 3,876
  • 7
  • 42
  • 72
1
vote
1 answer

Tsql - getting list of instances in the alwayson Availability group

I want to connect to the listener in the AlwaysOn availability group and by running a query I will get the list of instances that are part of the AlwaysOn . For example: I has listener "MylistenerHost" and there are 2 instances connecting to him:…
itzik Paz
  • 403
  • 5
  • 14
1
vote
2 answers

Azure Internet Facing Multi Region Load Balancer

I am creating a multi region AlwaysOn Sql Availabilty group. I have 2 VM's in the East and 1 VM in the West. I need to load balance these with a public facing load balancer. Is it possible to create an internet facing load balancer with VM's that…
Derek Williams
  • 525
  • 6
  • 21
1
vote
1 answer

Exclude database from being in AlwaysOn Group

Can I create a database on a primary server (such as a dba respository db) that is not a part of the AlwaysOn Group? Therefore it will only reside on the primary and not be on the secondary replica. Just create database and that's it? Thanks.
Sequel Surfer
  • 23
  • 4
1
vote
1 answer

AlwaysOn with TDE and Downtime

I'm fairly new to using TDE encryption with AlwaysOn Availability Groups. I have a few questions regarding application of the TDE certificate on a live database instance: What kind of downtime have you experienced for enabling encryption on a SQL…
Steve Hold
  • 25
  • 4
1
vote
0 answers

Query errors during Availability Group failover

I have a C# OLTP application that runs against SQL Server 2012. I want it to run without interruption in the case of a failover when its database is in an AlwaysOn Availability Group. In order to recover from transactions that are interrupted due to…
Dan Hermann
  • 1,107
  • 1
  • 13
  • 27
1
vote
1 answer

AlwaysON SQL Server 2014 Application exception: Failed to update database because database is readonly

We have two nodes availability group. The two nodes being SQL cluster1- node1 and SQL cluster 2- node2 and a Availability group listener. The Java application is connecting to this listener and all is working fine initially i.e application is able…
Crabster
  • 135
  • 11
1
vote
0 answers

SQL Server Always On and Connection Pooling

I'm trying to figure out an issue that I'm seeing when you setup a readonly replica. I have a simple application that will query the readonly replica and I can validate that it hits the correct one by running a @@servername. Everything works as…
jdgonzalez
  • 81
  • 7
1
vote
0 answers

SQL Server 2014 read only connections not forwarding after reboot

I have a four node SQL Server 2014 (12.0.4416) environment with one node acting as a read only node. When I setup routing, I can use the applicationintent = readonly property and everything seems to work. My connections that use applicationintent…
jdgonzalez
  • 81
  • 7
1
vote
1 answer

Database mirroring between different versions of sql server instances

We had two SQL Server 2008R2 instances A and B. We used database mirroring for a 1TB database from A to B - created a database snapshot on B for that 1TB database (which took 5 seconds) - and used that database snapshot for reporting. We upgraded…
databash
  • 656
  • 6
  • 19
1
vote
1 answer

Join an Existing Database to An Availability Group

I'm porting some existing (dynamic) SQL to C# via the SMO namespace. I'm having a little trouble figuring out how to join an existing database to my AlwaysOn Availability Group, though. The SMO namespace has a Database object and an…
Dan Forbes
  • 2,734
  • 3
  • 30
  • 60
1 2 3
…
13 14