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
42 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 ...
5
votes
2answers
125 views
How do I change SQL Server 2012 Availability Group DNS subdomain?
Questions: how can I get my availability group to be registered as ag-ewgtest.sql.company.com given that my server thinks of itself as server.company.com.
Setup: my SQL Server 2012 availability ...
1
vote
1answer
45 views
SQL Server 2012 Availability group disk configuration options
Background
I am quite far into the process of setting up a 2 server SQL Server 2012 Always on availability cluster to provide redundancy with a readable secondary replica of all our databases.
Since ...
0
votes
1answer
94 views
SSIS SQL Server 2012 cluster Availibility Group
We have a three server cluster using AlwaysOn technology, and have created an Availability Group for the SSISDB catalog.
How would you change the code to only execute on the primary server?
3
votes
1answer
89 views
SQL availability groups log maintenance
I have a AG with 2 nodes in a site in sync mode and 1 offsite in async mode. I'm having trouble understanding how the logspace is maintained in this scenario. For instance, I'm taking log backups ...
4
votes
1answer
208 views
Specifying the failover partner when using Availability Groups
We have a situation where we are using replicated databases in an environment that's making use of Availability Groups. As we wanted no manual intervention when failing over, we decided to set up ...
3
votes
1answer
362 views
AG and SQL Backups
I am using always on in sql 2012 and have an AG setup. I would like to know if i were to backup the primary database and restore it would that be allowed without taking the cluster down etc.
...
3
votes
1answer
106 views
Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2?
[Cross post from StackOverflow]
Brent Ozar published this webcast (slides, video with free registration) entitled "Real-Life SQL Server 2012: AlwaysOn Lessons Learned", in which he repeatedly states, ...
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 ...
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 ...
1
vote
1answer
78 views
Do locks on readonly secondary databases propagate to the Read/Write Database
I'm thinking about using SQL Server Availability Groups in SQL Server 2012 to offload reporting on our main database to a second read only server that is kept in sync through the availability group.
...
2
votes
0answers
176 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 ...
3
votes
1answer
461 views
Enabling Service Broker on a database involved in an availability group
I'm trying to enable Service Broker on a SQL Server 2012 database that is part of an availability group and keep getting this error message:
The operation cannot be performed on database "dbname" ...
3
votes
1answer
383 views
Service Broker & AlwaysOn Availability Groups: Odd Transmission Queue Behavior
I have also posted this question on my blog: http://www.sqldiablo.com/2012/04/15/service-broker-alwayson-availability-groups-odd-transmission-queue-behavior/.
I’ve been working on a project over the ...
4
votes
1answer
371 views
Transaction Log Truncation with Copy Only
I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
4
votes
1answer
221 views
Mirroring and Availability Groups in SQL2012
I've been looking at the new features of SQL 2012, and how it can help my current situation.
Currently we're on SQL 2008R2, and replicate two OLTP servers' databases to a single reporting server via ...
0
votes
1answer
130 views
AlwaysOn SQL Server setup questions
I just have a few questions regarding the setup of Always On HA, and Clusters. When you setup an AG, and it gets to setting up your IP address for the cluster how can i switch from using DHCP to a ...
