The alwayson tag has no wiki summary.
6
votes
1answer
584 views
Can the SQL Server 2012 Always On feature provide seamless failover (with no query failures)?
I have been testing the the Always On high availability 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 ...
6
votes
1answer
189 views
Recovery time effects of AlwaysOn
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 ...
5
votes
2answers
322 views
How to handle sql server database logins when using AlwaysOn. (they aren't syncing)
We have 2 servers in an AlwaysOn group.
While the user accounts within each syncronized database exist on both servers, the database instance level logins only exist on one of the servers. Ie ...
5
votes
2answers
312 views
How does SQL Server AlwaysOn work with help with scheduled jobs and SSIS packages?
I have 2 sql servers set up with a database within 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 ...
4
votes
1answer
82 views
Preferred node for read on AlwaysOn 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 fiber ...
4
votes
1answer
119 views
Enable TDE for existing AlwaysOn databases
I need to do a little benchmarking of AlwaysOn, both with and without TDE enabled. All the instructions I see cover adding encrypted databases to an availability group, but I see no mention of ...
4
votes
1answer
723 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 ...
3
votes
2answers
244 views
Can CDC or Change Tracking be implemented against a SQL Server 2012 AlwaysOn read only secondary?
We will be deploying SQL Server 2012 AlwaysOn with read only secondaries and would like to execute our SSIS extracts against the secondary while utilizing CDC or change tracking (the decision hasn't ...
3
votes
1answer
133 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 ...
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, ...
3
votes
1answer
167 views
Cross Database transactions - Always on
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 ...
2
votes
1answer
68 views
Always On and Partition Swapping
Is it possible to use SQL 2012 Always On over two machines and perform partition swapping on the primary machine ?
2
votes
1answer
213 views
SQL Server 2012 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 ...
2
votes
1answer
324 views
SQL Server 2012 Always On 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 ...
2
votes
1answer
1k views
Does Sql Server 2012 Always On support Active/Passive?
I am looking into the licensing of SQL Server 2012 when using Always on with 2 servers.
It is not clear to me if Always On is only available as Active/Active and not Active/Passive.
For reference I ...
1
vote
4answers
315 views
SQL Server 2012 AlwaysOn: need to automatically add databases by script- T-sql or PowerShell
I've installed and successfully configured our SQL Server 2012 AlwaysOn 2-node servers for our new "Intranet" that is coming out. I've gotten AlwaysOn working great, and our Front End servers for the ...
1
vote
1answer
86 views
SQL Server 2012, Network for: AlwaysOn Availability Group with AlwaysOn AlwaysOn Failover Cluster Instances
Setup: I have two data centers. In site1, my primary site, I'd like to deploy an AlwaysOn Failover Cluster Instance (FCI). In site2, my data recovery site, I'd like to deploy a single-node instance of ...
1
vote
0answers
22 views
DPM and AlwaysOn - Can they work
How does AlwaysOn tie into DPM for SQL Server 2012? Can we use one or the other for High Availability ? Can they work together or must they be used separately. Thanks
1
vote
1answer
87 views
Set up AlwaysOn in virtual environment: How to add nodes to domain? [closed]
On a beefy server, I have a few Virtual Machines (VMs) running. On one of those, I have Domain Controller (DC) with a domain name (ex:SQL.AD.COM) running successfully. Now, I need to add the other VMs ...
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 ...
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
98 views
Difference between accessing SQL Server by instance name and cluster name [closed]
I have installed failover clustering feature on two servers with Windows Server 2012 and then I installed SQL Server 2012 on both of them. I also enabled SQL Server 2012 AlwaysOn feature.
Now I can ...
