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.

learn more… | top users | synonyms (1)

1
vote
2answers
64 views

Can I access the file stream shared folder using Listeners in case of AlwaysOn cluster environment?

One of the most effective ways to extend your SQL Server Integration Services (SSIS) control flow is to use a Script task to write custom code that perform tasks you cannot perform with the built-in ...
0
votes
1answer
46 views

Backup transaction log from secondary database in alwayson AG

Is it possible to do the log backup from the secondary databases in the AG?
1
vote
1answer
92 views

FILESTREAM shared folder can not be accessed using listener name

I have AlwaysOn configured in SQL Server 2014 and enabled Filestream in both nodes (node 1 and node2) as shown here: Enable and Configure FILESTREAM (MSDN Library) I have named the shared folder ...
4
votes
2answers
63 views

Quickest way to migrate mirroring to AG

Scenario is this, prod is two two node FCI with mirroring (primary/disaster DC). This is working just fine. New hardware is coming and a version upgrade to SQL Server 2012 (from 2008 R2) in the form ...
2
votes
3answers
153 views

How to configure SSIS in SQL Server AlwaysOn

I have AlwaysOn Availability Group setup for my SQL Server. Now I would like to configure SSIS. How do I do it? Below link provides some information but since I am not DBA it's difficult to understand ...
0
votes
1answer
15 views

Installing a SQL Server patch on a node within a 2-Node FCI

When installing a SQL patch on a 2-Node Automatic FCI with a shared disk (in the same datacenter / same subnet), with quorum achieved by Node and FileShare Majority, is it possible to install a SQL ...
0
votes
0answers
41 views

Cluster network name resource 'XYZ' cannot be brought online

I have given wrong name for listener while configuring the always on in SQL Server management studio. One option I can see is deleting and re-creating the listener, But is it right way of doing ...
0
votes
1answer
33 views

What clustering features are required to implement Availability Groups?

My understanding is that if one wants to implement Always On / Availability Groups (without FCI) the Windows Clustering Service would need to be installed, i.e. a Windows Cluster is required but not a ...
1
vote
1answer
42 views

SQL Server 2012 AlwaysOn Availability Group active/passive

I have one Primary and one secondary replica on WSFC and AAG configuration. Both nodes are physical machines and sync with automatic fail over. The secondary replica is readable and we run ...
1
vote
2answers
101 views

High latency with SQL Server 2014 Synchronous AlwaysOn

I've built a SQL 2014 cluster in our development environment that consists of 2 nodes. Non-Shared disks Specifications: Storage is Nimble Storage Array with dedicated LUN's presented to the ...
0
votes
1answer
30 views

is it possible to use AAG with two 2-Node Clusters across two datacenters?

Is the following scenario possible? 2-Node Automatic Failover Cluster in DC1, shared disk 2-Node Automatic Failover Cluster in DC2, shared disk employ a 'Node and Disk Majority' employ AAG across ...
0
votes
1answer
31 views

is it problematic to cluster across two datacenters w/aag?

In general is it problematic to cluster across two datacenters that are up to 15-miles apart? For this one particular project the approach is the following? 2-Node Failover Cluster across two ...
0
votes
1answer
29 views

Primary server 'XYZ' can not write to shared drive during availability group configuration

I am in a process of adding databases to availability group. In one of the steps it was asking "data synchronization prefferences" as shown below I have put the mapped drive location path, which ...
2
votes
1answer
37 views

Availability Group Monitoring Redo Rates

We currently use Idera Diagnostic Manager to monitor our SQL environment, which now includes a couple of Availability Groups. Idera monitors the redo synch rates and starts to complain when the rates ...
0
votes
1answer
28 views

I do not see SQL Server instance name under roles section of Fail over cluster manager screen! How to setup?

I have created 2 Virtual machines in azure and configured Windows Cluster using fail over feature. I have enabled the "AlwaysOn" feature in SQL Server Configuration Manager. But I do not anything ...
1
vote
1answer
67 views

Shared network location in Availability Groups configuration

I am configuring Availability Groups feature in azure virtual machines nodes. In the below screen wizard, it's asking me for shared location. where and how I need to create this shared location? Do ...
3
votes
0answers
49 views

SQL Server logins “un-sync” when Availability Group fails over

I have 2 SQL Servers in an Availability Group. The logins are manually synced – same SID, same Password Hash, etc. on both replicas – and the user can log in via the listener to the primary replica. ...
0
votes
1answer
18 views

SQL Server Partially Contained Databases and Linked Servers

What is the work around for using linked servers with partially contained DBs? Additionally, how would this work with Always on and a secondary replica?
0
votes
1answer
41 views

How to enable/disable SQL agent jobs during fail over (AlwaysOn)

Note: this is not duplicate question. I have setup AlwaysOn. I have created SQL agent jobs manually on both the nodes. right now all the active jobs are running if node is PRIMARY. Challenge My ...
0
votes
1answer
19 views

On which node first transaction will be executed in Always-on setup?

I have a scenario where SQL Server 2012 - Always-on feature configured.The primary and secondary are synchronous for failover purposes. I understand that we will have node 1 (PRIMARY) and node 2 . ...
0
votes
2answers
110 views

Availability Group how to determine last Failover time

I'd just like to know if there is any way to query when the AG group failed over. eg - this is the Primary Replica now, but I'm pretty sure it was the secondary yesterday? How can i find when the ...
0
votes
1answer
92 views

AlwaysON Availability group query very slow

I am running below tsql to find the secondary AlwaysON servers from the primary replica : set transaction isolation level read uncommitted set statistics time, io on SELECT ...
0
votes
0answers
36 views

AlwaysOn Error and Redo Queue

Recently one of our synchronous AlwaysOn Groups stopped replicating data and went into a Non Synchronising state. In the dashboard on the primary everything was showing as OK, but on the secondary ...
1
vote
0answers
18 views

Restore log backups to non-readable async AlwaysOn replica [duplicate]

We have 3 SQL 2014 instances in a AlwaysOn Availability Group. Our 2 primary servers are onsite at our primary data center in synchronous replication. A 3rd replica is at our DR site in Async Mode (no ...
0
votes
0answers
62 views

Azure Availability Group Listener only works on Primary node

I am trying to troubleshoot an issue with an Availability Group in an Azure environment. Since I have no idea how the listener was originally setup, I'm not sure how to troubleshoot the issue. They ...
3
votes
1answer
56 views

Are Availability Groups feasible for 4 TB of data?

Currently we have a database which is 4 TB in size. We would like to put it in a 2014 Availability Group to scale out reads. Data gets changed a lot inside this database. I have following questions: ...
0
votes
1answer
101 views

Apply SP3 on SQL Server 2012 AlwaysOn AAGs

If Always-On is configured, while applying Service Pack, should I: Directly move SQL Server Instance (Secondary Replica) to make it passive and apply Service Pack Or First move Availability Group ...
1
vote
1answer
43 views

Always-On Configuration Clarifications

Do we have to Install stand-alone instances of SQL Server 2012 or Failover-Cluster SQL Server Instances while configuring Always-On? I am asking this question because I saw few configurations using ...
0
votes
1answer
66 views

Setting up log shipping with an availability group

In my production environment I have a SQL Server 2012 AlwaysOn AG. The Server1 there is database "MessagesDB" and in an AG to secondary Server2 (in synchronous mode). I want to setup log shipping ...
0
votes
1answer
31 views

Always on viability/configuration for very specific purpose

We need to know the risks/pitfalls of a particular AlwaysOn configuration. We want an AlwaysOn configuration with the following requirements(below). My question is: Is this a sound configuration or ...
0
votes
1answer
43 views

SQL Server AlwaysOn AG Synchronous

In a SQL Server AlwaysOn AG synchronous mode scenario, if the secondary node goes down, is the primary down as well (since it cannot write to and commit to the secondary)?
2
votes
1answer
98 views

High Availibility Solution to send data to multiple locations

I inherited a very interesting environment and I'm tasked with finding and implementing High Availability/Disaster Recovery solution as soon as possible. Simply speaking our environment looks like ...
2
votes
1answer
309 views

Availability Group database stuck in Not Synchronizing / Recovery Pending mode

While upgrading the storage in a SQL Server 2014 SP1 (12.0.4422.0) instance we ran in to an issue where two of the databases would not start on the secondary after restarting SQL Server. The server ...
3
votes
1answer
60 views

Traditional failover clustering vs. Availability Groups

I'm looking into Availability Groups to see if i can benefit from them, but I struggle to understand if I can or not. Today, we are running a traditional failover cluster with around 150 databases. ...
0
votes
1answer
37 views

Max redo speed on replica side in Availability Group

I heard about maximum 50 Mb/sec for receive and 50Mb/sec for redo. But really, I have only 20Mb/sec redo speed. This is speed from Perfmon, so I know about the following issue: AlwaysOn ...
2
votes
0answers
35 views

AlwaysOn Multi Subnet Configuration

Environment Two Nodes A & B A - Site/Subnet 1 B - Site/Subnet 2 File Share - at Site 3 We have an AG listener that has two IP addresses spanning the two subnets (1 up, the other down ...
3
votes
0answers
21 views

How to use a different vlan for mirroring in an availability group

I want to setup the following with SQL Server 2014 Enterprise and Windows Server 2012 R2. I have two nodes and a fileshare for witness. Both are virtual machines in the same vsphere cluster. To minize ...
0
votes
1answer
48 views

Practicing AlwaysOn on SQL Server 2014 - Windows 10 Home

TL;DR: What possible solution(s) are there to practice AlwaysOn feature on SQL server 2014 installed on Windows 10 Home edition? I am learning Database Administration on my own and have installed ...
2
votes
1answer
87 views

SQL AlwaysOn & System Center Configuration Manager TP 4 1601

Recently Microsoft released Technical Preview 4 for Configuration Manager (1601). Per TechNet, "Configuration Manager now supports using a SQL Server AlwaysOn availability groups to host the site ...
1
vote
1answer
54 views

Readable secondary

I set my readable secondary to read intent only and I ran my application without application intent = readonly and start a trace on the secondary node to make sure we are not reading from the ...
0
votes
0answers
65 views

Unable to create availability group

While trying to create an availability group, I am getting the below error. Can someone find the root cause of this? I even granted "create computer objects" permission, but it still did not work. ...
2
votes
1answer
34 views

SQL Always on Availability LSN Query

Please can somebody explain how the following works: Scenario: Two nodes in always on availability group configuration (all databases). If I have a backup job on node 1 to backup Full and Log ...
0
votes
0answers
103 views

AG Automatic Failover when SQL Server service shut down

I set up an availability group listener, and am able to failover manually without data loss. If I reboot the host OS, it fails over automatically. However, when I stop the SQL Service on the node ...
0
votes
0answers
62 views

Backup plan fails with error code 0x80004003

We have a maintenance plan that backups logs every 10 minutes at primary AlwaysOn group(don't sure that this is relevant info). Once in a while this plan's job fails with error: Code: 0xC0024104 ...
0
votes
0answers
12 views

Always On to separate Reads/Writes — safely doable with MSDTC cooked into app?

We are currently running SQL 2014 Enterprise Edition in AWS (EC2 instances, not RDS). We have a pressing need to separate out READS and WRITES, so that report queries don’t impact other processes. ...
3
votes
1answer
118 views

Multi Subnet Availability Group IP Requirement for Windows Failover Cluster

Does the Windows Failover Cluster for a multi-subnet SQL Server Availability Group require a static IP entry for each subnet? The instructions I am finding for a Failover Cluster Instance (FCI) in a ...
-1
votes
1answer
41 views

AlwaysOn Multi-Subnet Setup

Without using SAN-to-SAN replication, how does data synchronization occur across subnets in a multi-subnet AlwaysOn (AVG) configuration? I want to setup a separate VLAN (replica lan) to synchronize ...
1
vote
1answer
29 views

SQL Server AG - Is there any case for un-clustering prior to certain operations?

I have a software company asking me to remove a database from a synchronous availability group prior to them running their upgrade scripts. They are convinced that this will increase the execution ...
3
votes
1answer
72 views

Mixed editions in Availability Group?

Looking to consolidate several different older SQL serves into one AG with an ent lic when Sql Server 2016 is released. Plan is to have a primary, a sync passive secondary, and an async third instance ...
1
vote
2answers
84 views

Remove a node from Failover Cluster

We had 5 SQL Server 2012 servers configured with AlwaysOn. A few days ago we dismissed 2 of them, we removed them from the availability group and then stopped SQL services. We need to reuse these ...