Tagged Questions

1
vote
4answers
323 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
1answer
88 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 ...
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, ...
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 ...
4
votes
1answer
120 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 ...
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?
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 ?
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
315 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 ...
3
votes
1answer
135 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 ...
5
votes
2answers
324 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 ...
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 ...
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 ...
2
votes
1answer
328 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 ...
6
votes
1answer
587 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 ...
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
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 ...
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 ...
4
votes
1answer
728 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 ...