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
0answers
13 views

SQL always on / SQL Failover Cluster

Is it possible to have two SQL instances on the same windows failover cluster with one instance using always on (no SQL failover cluster), and the second instance belonging to a SQL failover cluster?
1
vote
1answer
31 views

can i shrink log file in full recovery model

i have configured Always on Availability group where iam unable to shrink log file size through simple recovery model. can i shrink the log file size in full recovery model if yes or possible then is ...
1
vote
0answers
16 views

SQL 2014 Availability Group Cluster or Listener

We recently deployed a setup of SQL 2014 availability groups and we are having some difficulty with the failover. Setup: Two windows server 2012R2 VMs in a windows cluster with a CNAME pointed at ...
1
vote
1answer
19 views

SQL 2014 AlwaysON Backup

I have 2 SQL server 2014 configured as AlwaysOn cluster. I've found that full backups are not supported on the secondary replica just read only backups. I have several questions regarding the issue ...
1
vote
1answer
44 views

AlwaysOn Manual failback not working correctly

I've set up a small fail over cluster using AlwaysOn in SQL Server 2014 and Windows 2012R2. The cluster (SQL-CLUSTER-DEMO) just contains 2 SQL nodes (SQL-01 [Primary] & SQL-02 [Secondary]) and a ...
3
votes
1answer
46 views

SQL Server 2014 Availability Group failed

I have 3 servers on VMware workstation: Win 2012 R2 as ADDC -Cluster service. Win 2012 R2 as SQL server primary replica . Win 2012 R2 as SQL server secondary replica (auto fail-over). My ...
1
vote
0answers
30 views

AlwaysOn Availability Groups

We are looking at setting up SQL AlwaysOn availability groups in the following environment: we have two SQL 2014 Enterprise Servers on two different host Hyper-V 2012 servers. They each have ...
0
votes
1answer
33 views

SQL Server 2014 - Replica Server not available

I'm new to Sql Server and want to install SQL server alwayson clustering on my test environment. I followed the steps by this site: On each node I can connect to SQL Server but why my 2nd node is not ...
0
votes
1answer
38 views

SQL Server 2012 AlwaysOn Availability Group

We have an application that needs access to the database all the time to work properly and we are planning on deploying SQL Server 2012 AlwaysOn Availability Groups on Windows Server 2012. We have ...
0
votes
0answers
36 views

Cluster Failure

Earlier this evening we received notice of failures in regard to the availability groups. Our plan is to fail it back over tonight, but we'd like to know the possible root cause of the initial ...
3
votes
1answer
62 views

Why is SAN Replication is Causing Random Database Corruption?

Having a strange issue with a disaster recovery technology we're trying to implement. The environment in both datacenters is the same having VMWare and Dell Equallogic SANs, which are the same ...
1
vote
1answer
30 views

Does our application work with sql-server AlwaysOn?

This is the question a client of ours is asking. For now I have given a generic response that we will support this however they should provide us with a test environment. Our application is using ...
1
vote
1answer
39 views

SQL Server 2014 AG Listener

I have built a two node SQL Server 2014 Always On cluster on the same subnet. I need to create two availability groups/listeners in the same instance for two sets of databases. Do I need two separate ...
3
votes
1answer
28 views

SQL Server 2012 Explicit transactions taking time with Always on Setup

We have a weird issue while we setup the AlwaysOn on Azure VM. We have explicit transactions in our stored procedures, and which are causing some delays and blocking when till the time we get the ...
1
vote
1answer
44 views

Adding Secondary Data file in SQL Always on

How to add the Secondary Data file to the Database which is a part of Always on availability Group in SQL Server 2012.
1
vote
1answer
35 views

Sql Server Licensing & Clustering for AlwaysOn

For Sql Server 2014, reading these MSDN link and Microsoft PDF file about licensing, created a couple of questions. For AlwaysOn do we need WSFC or FCI? How are WSFC and FCI different? If we only ...
1
vote
0answers
16 views

AlwaysOn AG Live Migration

A couple of thoughts on AlwaysOn AG migrations: Is there a reason why Microsoft didn't implement similar technology to Hyper-V Live Migration to AlwaysOn AGs so that the buffer pool and cache are ...
1
vote
1answer
37 views

Do Triggers in the Active Secondary Database of an AlwaysOn Group Execute?

If I have triggers on tables in a database that is a member of an AlwaysOn group, will they fire on the secondary? If they do fire, and they do something different on the secondary will it matter as ...
4
votes
1answer
70 views

Why are these two HADR DMVs reporting different states?

SQL Server 2012 (11.0.5058.0) Enterprise Edition We have 8 Availability Groups in a 2(HA)+1(DR) cluster and our monitoring DMVs are reporting results that confuse me. 6 Availability Groups are ...
3
votes
1answer
69 views

Create Linked Server to AlwaysOn Availability Group Listener

I have an alwayson availability group setup using SQL 2014 and Windows Server 2012 R2. There are 3 nodes in the group. The SQL Service is running as a Managed Service account on each node (1 MSA for ...
0
votes
1answer
20 views

How can SQL server AlwaysOn AG can be used as a DR feature?

I'm using AlwaysOn ag feature as a HA feature where automatic failover is possible.. I was thinking to log shipping as DR but there is potential data loss in that.. thinking of using ag as a ...
3
votes
1answer
97 views

Service Credentials to use in AlwaysOn Availability Groups?

When using AlwaysOn Availability Groups does each SQL Instance need to use the same service credentials? We are setting up a new SQL2014 deployment and will be using AlwaysOn. If I have 2 SQL servers ...
0
votes
1answer
20 views

Replicate a database to one secondary replica, but not the other secondary replica using Availability Group

I have a 3 nodes cluster in an availability group. There are two databases on the primary node. One database I want to replicate to the 2 secondary nodes. Another database I just want to replicate ...
2
votes
1answer
49 views

Is there a TSQL command or another way to rename AOAG (Always On Availability Group)?

We have an AOAG named with "space" and I need to rename it to not have "spaces". It was created before my time. The 3rd party vendor tool does not work with AOAG that has spaces. There are about 40 ...
0
votes
1answer
107 views

CLR Assemblies and SQL Server Availability Groups

I have a SQL 2012 Availability group. On that I also have a database with a .Net assembly that is using PERMISSION_SET = UNSAFE. CREATE ASSEMBLY drawing FROM ...
0
votes
0answers
26 views

2012 Always on (AG only) Where should the Windows Cluster SIT?

2012 Always On and the Windows Cluster, shouldn't the Windows Cluster be on a separate server like the Domain controller/BackupDomainController? With Windows clustering Services on each node ...
0
votes
0answers
17 views

Login synchronization in 2012 AlwaysOn

I have a rather unique situation (or so it seems since there isn't anything I've found on the web about this). I have an AlwaysOn Availability Group configured without HA Failover, to an asynchronous ...
0
votes
0answers
19 views

Shrink MDF and LDF files when database is in always on SQL server 2014 [duplicate]

Can we shrink the log files in the SQL Server when the database are on always on feature?
0
votes
0answers
342 views

The Service Broker endpoint is in disabled or stopped state - AoAG - SQL Server 2012 - 15 minute interval

I receive this error message in SQL Server error log every 15 minutes. I have setup AOAG on this server. The database option "Service Broker - Broker Enabled" is turned on for the Blackberry related ...
2
votes
1answer
73 views

DR option for SharePoint databases? ideas and experiences

First let me clarify that I am not looking for thoughts in terms what is the best or the bad options for a DR for SQL Server. I am just looking for for inputs from experienced people. We are running ...
1
vote
1answer
36 views

AlwaysOn Listener and DNS

We have two DNS servers which replicate entried between them and we recently had a DNS issue where some of the listener addresses were removed from one of the servers only. At that point some of our ...
0
votes
1answer
36 views

Having trouble designing my preferred backup scheme

First some background: I have two Windows servers running MS-SQL-2014 setup in an availability group (synchronous auto-failover, preferred backup on secondary). They host many databases. Right now ...
4
votes
2answers
96 views

AlwaysOn Availability Groups back up schedules

We have AlwaysOn Availability Groups primary and secondary replicas where the secondary replica is preferred for back up jobs to take place as long as it is available. I created back up jobs on both ...
2
votes
1answer
31 views

Can't create an Availability Group with Powershell when instance uses non-standard port

I am trying to create an Always On Availability Group with PowerShell, something I have done many times before but am hitting an issue now that I am using non-standard ports for the SQL Instance I ...
1
vote
2answers
52 views

Where is Connection String Located as it relates to Availability Group Listeners?

I am trying to teach myself about Availability Group Listeners and see that I need to update a "Connection String." I know that I have a connection string in my web.config file on the Web server, but ...
2
votes
0answers
47 views

Replacing Database in High Availability Group Enviroment

Looking for some advice regarding replacing a database within a SQL 2012 High Availability Group environment setup as synchronous with auto failover. A little bit of background on the reason for this. ...
0
votes
1answer
65 views

SQL AlwaysOn Data Sync

We are in the planning phase to implement AlwaysOn Availability Groups. What is the best practice to setup the file share for data synchronization? Network path or local machine (creating a share on ...
1
vote
1answer
100 views

SQL Service Broker and AlwaysOn Issue

I'm having an issue setting up my current environment using AlwaysOn and SSB and I'll try to explain as best as I can here: Current environment: Server A Server B database x(Pub) ...
0
votes
0answers
45 views

Do I need a separate server for Quorum?

We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: 1 Primary Replica and another is Secondary Replica. The question is, do we need a separate server ...
0
votes
2answers
99 views

How many records should be deleted when batch delete is used?

I am going to migrate a large amount of data from one table to other table. The target data source table has foreign key constrains, so I am not able to use DELETE with OUTPUT clause, but need to have ...
7
votes
1answer
284 views

SSMS Registered Servers with ReadOnly Application Intent

We are working on SQL Server 2014 POC testing with AlwaysOn and one of the user asked about saving the configuration of SSMS with ReadOnly Intent using the registered servers in Local server group. ...
1
vote
0answers
43 views

Alwayson Database Recovery Failure during TDE encryption

Last week I enabled TDE encryption on my AlwaysOn Availability Group databases of SQL Server 2012. During the encryption of one of the larger databases, bigDB (~200gb) a failover event occurred. Of ...
4
votes
1answer
134 views

AlwaysOn AG - CPU limitations

I’ve been trying to find out if the same CPU limitations database mirroring has apply to Availability Groups. My guess is that the same limitations exists, given that Availability Groups was built on ...
2
votes
1answer
61 views

SQL AlwaysOn Availability 2 synchronous nodes on either side of an asynchronous link

Say we have two datacentres, DC-A and DC-B. Say in each DC, there are two SQL servers. DC-A has SQL-A1 and SQL-A2 and DC-B has SQL-B1 and SQL-B2. Is it possible to have SQL with an AlwaysOn ...
3
votes
1answer
129 views

Manual Failover with AlwaysOn availability group

We are planning to upgrade our SQL 2012 to SQL 2014. We currently use a mirror for our production databases but are planning to move to availability groups. We are going to be running 2 SQL Servers on ...
2
votes
2answers
292 views

How to query readonly replica in Always On cluster

We have an Always On "cluster" that consists of 2 servers (there will be more), so one is PRIMARY and other(s) is(are) SECONDARY. The idea was to dedicate SECONDARY as a readonly replica, so it would ...
1
vote
1answer
94 views

SQL Server Availability Group Design Question/RFC

We are in the early stages of planning an upgrade/redesign of our SQL environment and I am seeking advice/feedback. The scenario: Current SQL Server 2008R2 EE on Windows Server 2008 R2, blade ...
1
vote
1answer
153 views

Restoring a Database in an Availability Group

I located an extremely helpful process outlined in the thread below, but needed some clarification. This may be a silly question, but I'm a bit new to Availability Groups. In the steps outlined in the ...
1
vote
1answer
46 views

SQL Cluster, AlwaysOn AG, or Something Else? [closed]

I really needs some help with Setting up SQL servers. We are re-configuring our network and have no clue how to resolve our SQL issue. My Network Admin. wants an "Active/Active" with shared storage ...
1
vote
0answers
130 views

SQL Server Management Studio with Multi subnet HADR cluster

We are starting to deploy Multi-Subnet HADR AlwaysOn clusters for our environment. Using MultiSubnetFailover=True in application connection strings works. However, SSMS connections require manual ...