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)

0
votes
0answers
7 views

Errror in Ag VALIDATE SHARED LOCATION

i Have this error when i create new AG Database Do any one have experience with this issue note: share network location not share in WSFC it's on another server all node and sql Services users ...
0
votes
1answer
16 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 "my publisher server(SQL01_REPLICATION) is running on 32 bit ...
0
votes
1answer
30 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
32 views

I'm confused about High Availability/Always On [on hold]

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 ...
1
vote
2answers
16 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
32 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
41 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
27 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
20 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 ...
0
votes
0answers
26 views

One-Way Database Synchronization with AlwaysOn Implementation

please give me advice for my database architecture.. According to below image AlwaysOn primary replica are synchronizing with two local database server. Our company is working on virtual call centre. ...
1
vote
0answers
27 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
22 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
23 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
40 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
35 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
54 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 ...
0
votes
1answer
26 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 ...
3
votes
1answer
31 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
22 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
14 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 ...
2
votes
2answers
50 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
57 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
31 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
66 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
62 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
88 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
13 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
30 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
30 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
36 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
80 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
28 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
28 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
27 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
29 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
24 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
58 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
48 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
17 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
30 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
68 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
74 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
33 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
17 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
56 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
53 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
61 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 ...
0
votes
1answer
39 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
51 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 ...