Availability Groups are a new feature of SQL Server 2012 that provide continuous data mirroring/replication and automatic failover for one or many SQL Server databases. They are part of and sometimes referred to as `AlwaysOn`.
1
vote
1answer
30 views
Startup procedure for availability replica becoming primary
Is there any way how to create a startup T-SQL script/procedure for starting availability replica (when state has changed from secondary to primary)?
I want to disable SSIS jobs specific for related ...
2
votes
0answers
47 views
What is correct process to physically move an availability replica to another location
Current situation is we have 3 SQL Servers with one availablity group and we plan on moving one of the secondary replicas out of HQ to another location. There will be the span of a few hours between ...
2
votes
0answers
173 views
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
I have two SQL Server instances in an availability group. They are not mirrored.
I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
1
vote
0answers
31 views
when can AG primary replica be a different host to WFC primary?
To set up an Availability Group with two servers, the servers both participate in a Windows Failover Cluster.
I've seen cases after certain failover modes where the primary IP address in the cluster ...
