Questions tagged [availability-groups]

Availability Groups are a new feature of SQL Server 2012 that provide continuous data synchronization, automatic failover and secondary read access for one or many SQL Server databases.

Filter by
Sorted by
Tagged with
3 votes
1 answer
581 views

Availability Groups and Partition Swapping

Is it possible to use SQL 2012 Availability Groups over two machines and perform partition swapping on the primary machine ?
user avatar
  • 2,777
7 votes
1 answer
2k views

Recovery time effects of Availability Groups

We did different kinds of basic Tests and AlwaysOn passed in many tests. We finally did a heavy write test for AlwaysOn and it gave surprising results. The actual Test details are here, the goal is ...
user avatar
  • 1,061
8 votes
2 answers
4k views

How do Availability Groups work with cheduled jobs and SSIS packages?

I have 2 SQL Servers set up with a database in an AlwaysOn Availability Group. I also have jobs set up which run against the database. During a failover how do I ensure the jobs will continue to run ...
user avatar
  • 507
7 votes
1 answer
8k views

How to link users and logins in an Availability Group?

I've got an Availability Group going and need to map some logins to database users on an active secondary replica. (Node2) Unfortunately, when I try to exec sp_change_users_login or alter user with ...
user avatar
13 votes
4 answers
27k views

Logins aren't syncing across Availability Groups

We have 2 servers in an AlwaysOn group. While the user accounts within each synchronized database exist on both servers, the database instance level logins only exist on one of the servers. Ie ...
user avatar
  • 507
6 votes
1 answer
941 views

Cross Database transactions with Availability Groups

Recently we are working on a POC to get Always on work and happened to see this article in BOL http://technet.microsoft.com/en-us/library/ms366279.aspx This article suggests that there would be ...
user avatar
4 votes
1 answer
200 views

Preferred node for read on Availability Group in a multisite configuration

We are going to set up a multi (at least 2) site configuration, and we want to achieve both HA as well as a good resource usage. The sites will be interconnected through a high speed, dedicated ...
user avatar
  • 143
2 votes
0 answers
4k 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 multiSubnetFailover=...
user avatar
6 votes
1 answer
18k views

Availability Group reporting disconnected replica

I'm trying to configure availability groups in a VM environment so I can run some tests. I think I've got the group created correctly, I can see the Always on group on both servers. However when I ...
user avatar
  • 516
9 votes
1 answer
5k views

Can Availability Groups provide seamless failover (with no query failures)?

I have been testing the Availability Groups feature in SQL Server 2012 and am finding that there is approximately 15 seconds of down time when the primary server fails over to the secondary server. ...
user avatar
  • 507
2 votes
1 answer
426 views

Availability Group configuration & licencing

I am about to setup a 3 node AV group for SQL Server 2012 my configuration will be - London-Srv1 - PRIMARY Core Database (OLTP) set to READ_WRITE London-Srv2 - SECONDARY PASSIVE synchronous Core ...
user avatar
  • 2,581
3 votes
1 answer
8k views

Do Availability Groups support Active/Passive? [closed]

I am looking into the licensing of SQL Server 2012 when using Availability Groups with 2 servers. It is not clear to me if Availability Groups are only available as Active/Active and not Active/...
user avatar
  • 507
11 votes
2 answers
2k views

SQL Server 2012 Availability Group is it "AlwaysON"?

In a traditional SQL Server cluster when failover occurs, all clients that are connected to the SQL Server failed instance lose connections and each client must re-establish a new connection to ...
user avatar
  • 2,961
6 votes
1 answer
12k 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" ...
user avatar
7 votes
2 answers
5k views

Can CDC or Change Tracking be against a read only secondary?

We will be deploying SQL Server 2012 Availability Groups with read only secondaries and would like to execute our SSIS extracts against the secondary while utilizing CDC or change tracking (the ...
user avatar
5 votes
1 answer
5k views

Trouble Creating AG Listener: The WSFC Cluster could not bring the Network Name resource

We are trying to create an AG Listener and it errors out on us: It does however seem to create both the DNS entries and the virtual computer object in AD. However, because of this error message SQL ...
user avatar
  • 2,335
6 votes
2 answers
3k 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 ...
user avatar
  • 388
4 votes
1 answer
208 views

Are there any best practices before moving SQL Server to another node (controlled failover)?

Let's say there are multiple jobs running on the SQL Server - we have index maintenance jobs, backups, replication, etc. We would like to perform a switchover using Failover Cluster Manager. Are there ...
user avatar
12 votes
2 answers
5k views

Do schema changes "break" Availability Groups or are they handled transparently?

My organization is planning to adopt SQL Server 2012 Availability Groups and I am trying to understand what impact (if any) it will have on our application upgrade process. We release application ...
user avatar
3 votes
1 answer
1k 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. ...
user avatar
  • 388
1 vote
1 answer
282 views

AlwaysOn SQL Server setup questions

I 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 static ...
user avatar
  • 388
4 votes
1 answer
770 views

How to determine high availability configuration is working correctly

I am in the process of setting up always on high availability clusters for the first time. Can anyone explain to me from the networking perspective after configuring the group and testing to make sure ...
user avatar
  • 388
8 votes
2 answers
2k views

Can Availability Groups replace transactional replication?

I've been looking at the new features of SQL Server 2012, and how it can help my current situation. Currently we're on SQL Server 2008 R2, and replicate two OLTP servers' databases to a single ...
user avatar
  • 267
7 votes
1 answer
3k 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 ...
user avatar

1
25 26 27 28
29