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
1answer
71 views

Very slow insert performance on large table (EF)

One of our systems has a table that receives around 20k inserts per day - it currently contains ~10m rows. We've just pushed out a system upgrade and I'm intermittently getting some shockingly slow ...
0
votes
1answer
110 views

SQL Server AlwaysOn Error:35250

I am configuring AlwaysOn in my test environment but getting the following error. Msg 35250, Level 16, State 7, Line 1 The connection to the primary replica is not active. The command cannot be ...
1
vote
1answer
46 views

CDC with AlwaysOn Availability Groups

So I just recently got to enable CDC on an always on AG. While many sources claimed enabling CDC on alwaysON AG is as easy as it is on any standalone server, turns out it really isn't. As MS says here:...
0
votes
1answer
42 views

Cannot read from secondary availability group

I have an issue with Always On Availability Groups In SQL Server 2012. I installed a replica secondary SQLNODE3. It was fine and everything retrievable form tables but suddenly I found I could not ...
0
votes
1answer
27 views

HADR procedures

We are thinking of a SQL Server 2014 + Windows Server 2012 configuration for a HADR scenario. My questions are: on a HA scenario, how does the primary server get updated once it is again available ?...
0
votes
0answers
48 views

Speed Up Garbage collection in FileStream process

In my current process, we have two production site SQL Servers 2014 (Sync), and one DR site SQL Server 2014 (ASync) in one WSFC. I will be hosting 5-6 databases for AOAG set up, out of which one of ...
0
votes
1answer
56 views

Transaction log changes not synchronizing with AlwaysOn

SQL Server 2012 Enterprise in an AlwaysOn configuration. The Availability Group for this specific DB is synchronized and healthy. I had to add a second transaction log file (logfile2) to the primary....
1
vote
1answer
71 views

patching SQL Server with Availability Group and Secondary Replica

Scenario: SQL Server 2014 CU6. 1 AG with 2 databases (compatibility level 100). Failover Cluster with 3 nodes on Windows Server 2012 R2. Primary Availability Replica on node 1 and node 2. Secondary ...
1
vote
1answer
43 views

DR Site availability if primary goes down

I have two SQL Servers at a production site (2 node WSFC) in an Availability Group, and one SQL Server at a DR site. If I add DR site node to existing WSFC to configure AOAG: If both servers at the ...
1
vote
1answer
34 views

File share Witness or Disk Witness

I have 2 SQL Servers at production site Windows Server Failover Cluster and 1 SQL Server at DR site. I will add the DR node to existing Windows cluster and configure AOAG. Should I go for File share ...
0
votes
0answers
25 views

Secondary database log file in alwayson is very big [duplicate]

I have an alwayson environment (AlwaysOn AG). Database [UsersDb] in the slave server, His log file is very big . How can I reduce his size(shrink)?
2
votes
1answer
60 views

SQL Server Always ON

We have a SQL Server 2008 R2 cluster with 2 node and total data is about 2 TB now that cluster is log ship to 4000 Miles another data center. I know about a 2 years back we have mirroring setup ...
0
votes
1answer
32 views

Log Backup in AlwaysOn

In our current process, log backup is done by log shipping backup job. Is there any need to configure backup job for transaction log in next AlwaysOn environment? If we must configure backup, we ...
1
vote
2answers
28 views

SQL Server Cluster + Availability Groups?

I'm actually finding a way to provide a good High Availability and Failover solution while I have a way to manage some sort of horizontal scalability and Load-Balancing... I actually have a SQLServer ...
0
votes
0answers
22 views

Quorum Drive needed?

Do I need a quorum drive for configuring Always On on SQL Server 2014? I am sure it is not mandatory as the 'last man standing' concept is based on node and disk majority. But I need a little more ...
-1
votes
2answers
30 views

Always On Stand Alones

Can I add a Stand Alone instance to a Windows Failover Cluster for Always On set up? I need to have one secondary synchronous replica with automatic failover.
4
votes
2answers
65 views

Statistics for AlwaysOn Availability DBs

Can you please help me understand why there is a need for SQL Server to maintain statistics in tempdb for DBs that are part of an Always On Availability Group? Isn't "everything" that happens in the ...
1
vote
3answers
82 views

AlwaysON - Force users connection to use Readable Secondary Nodes

I'm implementing SQL Server 2015 Enterprise on my actual client, using Always On Availability Groups. Processes like Reporting, ETL (extraction of data), and read workload are being redirected to the ...
1
vote
1answer
53 views

AlwaysOn Synchronous Mode Possibilty

We have 2 SQL Servers at Production site and 1 SQL Server at DR site. Please correct below things as I am not getting clear idea about these sync mode in AlwaysOn: If I install SQL Server FCIs in ...
0
votes
0answers
32 views

Tsql - getting list of instances in the alwayson Availability group

I want to connect to the listener in the AlwaysOn availability group and by running a query I will get the list of instances that are part of the AlwaysOn . For example: I has listener "MylistenerHost"...
0
votes
2answers
36 views

AlwaysOn Async read takes more time when compared to that of Sync secondary [closed]

AlwaysOn Async read takes more time when compared to that of Sync secondary (by a small fraction). Is this expected behaviour? I was under the impression that ASYNC must be faster than the SYNC.
0
votes
1answer
70 views

SQL 2012 Availability Group issue - The core cluster resources do not move when we initiate AG fail-over

I have a Windows 2012R2 cluster with two nodes and a File Share quorum. I am running SQL 2012 SP2 and I have configured a test AG with a dummy database. When I fail-over the AG, the Availability ...
0
votes
1answer
36 views

Transactional Replication with Always On via Sql Server 2014

My Scenario is given below...i want to configure transactional replication with alwayson and i know this is possible but my question is "I have two publisher sql server(SQL01_REPLICATION) is running ...
0
votes
1answer
53 views

Sql service account password change for environment on Availability groups 2012

My current environment is on Availability groups sql 2012 with 1 Synchronous and 1 Asynchronous replica. Soon we need to change the sql service account passwords. Can any one suggest to me do I need ...
1
vote
2answers
52 views

I'm confused about High Availability/Always On

is High Availability something to describe Log Shipping and Always On ( replica )? is Always on something to describe Log Shipping and High Availability? I'm studying to get my certification 40-762 ...
0
votes
1answer
68 views

Powershell invoke sqlcmd

How is it possible to execute a query as a applicationintent=readonly using powershell? I have an cluster alwayson environment. I want to call a procedure with invoke sqlcmd to the readonly database ...
1
vote
2answers
45 views

Setting up a listener for sql server alwayson availability groups without computer object rights in the AD

Is there a way to create a sql server alwayson listener in an active directory (AD) environment where I don’t have create computer object rights? The AD admin created a computername for me. Is there a ...
1
vote
2answers
53 views

Can we have dynamic SQL jobs in SQL Server Availability groups

We need to push all sql data changes to our local caching infrastructure in real time. We are using SQL Server 2012 Availability Groups. In the process of avoiding triggers for population SQL Service ...
1
vote
1answer
53 views

Add New Cluster node

I have a Windows Server 2012 Failover Clustering Instance, hosting a SQL Server 2012 Enterprise Cluster, via NODE1 and NODE2. I need to add a new read-only Replica to this cluster: NODE3, which is a ...
2
votes
2answers
43 views

Transactional replication subscriber vs AG secondary replica for reporting

I am trying to recommend my client a SQL server upgrade (from 2005-> 2014) which will allow the users to create record snapshot (via SSRS) from a read-only data source. Data latency should be kept to ...
1
vote
1answer
35 views

Accessing file share from ETL package in SQL Always-On configuration

How can I access the file share from ETL? Here are my environment details: I have 2 nodes in a windows cluster. node 01 and node 02 SQL Server 2014 is installed on both the nodes. Both are Windows ...
1
vote
0answers
29 views

Synchronization report for uncontained objects across each of the replicas in HAG

I have seen How to transfer logins and passwords between instances of SQL Server , Synchronize Availability Group Logins and Jobs and SQL Server 2012 Availability Group Add-in to synchronize ...
0
votes
0answers
57 views

SAN replication vs AlwaysOn vs something else?

Working on a DR project at the moment, we have our primary location which is all setup. Our secondary location has most of the hardware we need already. We have a Microsoft SQL driven web application. ...
0
votes
1answer
45 views

WSFC File Share Witness

I've got a multi-site 2008 R2 WSFC with a file share witness. I noticed that the possible owners for the FSW is every node in the cluster. I thought the concept of a FSW was that no node of the ...
1
vote
1answer
80 views

ReportServerTempDB in AlwaysOn Availability group

ReportserverTempdb logfile is 6TB in size and growing and I need help. I am supporting a huge reporting server farm and the client wants reporting services to be in AlawysON Availability group(AAG) ...
4
votes
0answers
52 views

HADR high worker thread usage

Why would an availability group's number of worker threads in an HADR pool increase well beyond minimum usage of "typically, there are 3–10 shared threads" per replica? In one case we've observed ...
1
vote
2answers
66 views

Script/tool to use to check when the server is not being heavily used and configuring backup on Availbility Groups

If I were to backup 50 databases in SQL server, I want to make sure that backup is taking place when the server is not that busy. Is there any way or script/tool to use to check when the server is not ...
0
votes
1answer
34 views

SQL Server 2014 log growing just in Navision 2015 just when always on is active

My question is about if anybody can help me to find out why my LOG file growing to more than 2T just when I activate ALWAYS ON in my NAVISION database. I have more databases in my SQL Server 2016 and ...
4
votes
1answer
33 views

Copy-only as the routine backup

We are in planning to upgrade from SQL Server 2008 R2 to SQL Server 2014, with the intention of using Availability Groups. One of the secondaries will be used to do backups. I have tested and ...
0
votes
1answer
28 views

Do you need SQL Server AAG when using SQL Server FCI/RAID10?

If I have a 2-Node AlwaysOn Automatic Failover Cluster Instance with a shared disk and RAID-5 or RAID-10 to account for a SAN failure with the same setup in a second datacenter with data propagation ...
0
votes
1answer
18 views

What is faster Asynchronous SAN Replication or Asynchronous AAG?

If copying data from one datacenter to another, what would generally be the faster approach to propagate that data to the target datacenter, SAN Replication or AAG, i.e. block-level or transaction-...
2
votes
2answers
114 views

Do you have to use a shared disk with AlwaysOn FCI?

Do you have to use a shared disk with AlwaysOn FCI in a 2-Node FCI? If not and if you have a 2-Node FCI and each node has a local SAN Disk can failover be automatic and will the whole instance ...
1
vote
2answers
80 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
79 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
0answers
133 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
68 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
298 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
19 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
60 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
36 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 ...