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
votes
0answers
19 views

Shrink LOG file in a Always ON [duplicate]

My LDF file is too big (almost 500 GB) because we had some problems. I know that is not good to shrink file, but we need to do it this time. My database is FULL RECOVERY MODE and it is in a Alwayson ...
1
vote
1answer
31 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
0answers
15 views

Linked server to Availability Group Listener

I am setting up a SQL 2014 AAG (2 replicas - HASQL1, HASQL2) on Windows Server 2012R2. I created an availability group (call it HAG) on them, and added a database (hadb). I set up a listener (call ...
-1
votes
0answers
6 views

WSFC Quorom query - 2012 R2

I have an three node AlwaysOn AG setup, running on SQL Server 2012 SP3 in Windows Server 2012 R2. Node 1 and Node 2 are in the same physical location. Node 2 is the secondary replica. Third node acts ...
1
vote
1answer
21 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 ...
1
vote
1answer
29 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
0answers
33 views

Quorum Questions For An FCI And AlwaysOn in a WSFC

I was reading the white paper on FCI + AlwaysOn as well as several other resources on quorum voting differences in Windows Server 2008 and 2014 and had 3 questions. 1- Will giving a node in the ...
0
votes
2answers
35 views

Multiple SQL Server instance install question for AlwaysOn

I have a 2 node WSFC cluster with SQL Server 2014 installed on each for AlwaysOn. This is working fine. My question is can I install another instance of SQL Server 2014 on these nodes for another ...
1
vote
2answers
67 views

Any different guidance for tempdb with Availability Groups?

I have an Availability Group set up on SQL Server 2014 running on a two-node Windows Server Failover Cluster. The setup consists of two stand-alone instances + synchronous with automatic failover. ...
1
vote
1answer
36 views

Login in Always On Availability Groups

I am new to Always On Availability Groups and I am little bit confused with creation of logins. Let's assume an environment NODE1(Primary) & NODE2(secondary) & NODE3(Stand by) & ...
0
votes
0answers
26 views

is it possible to use SQL Server listener IP to the application?

I have 2 application servers and I have SQL Server clusters with always on high availability. I need to point my application server database to the SQL Server listener IP. Is it possible ? if so ...
1
vote
1answer
71 views

Scheduling index rebuild jobs

I have a MS-SQL 2014 SP1 - two node AlwaysOn AG (One Primary and an read-only secondary) with about 10 databases sizing 20-30GB in total. I have some queries regarding scheduling index rebuild and ...
2
votes
1answer
1k views

Fastest way to migrate database to AlwaysOn cluster

I want to make the fastest migration plan to move a SQL Server database in simple recovery from a standalone server (SQL 2005) to a two node AlwaysOn cluster in full recovery. Some databases are ...
1
vote
1answer
1k views

RegisterAllProvidersIP 1 or 0 For The Cluster Resource

I have set up clustering across two sites, at each site there is a single instance of SQL 2014 enterprise and I am using Availability Groups. I know I need to set RegisterAllProvidersIP for the AG ...
-1
votes
0answers
15 views

Installing a Failover Cluster Instance on a Cluster already in use for Instances hosting Always On

I have been asked to install a SQL Server FCI on a 3 nodes cluster already hosting 4 different instances with Always On Availability Groups. While I am building the lab on my machine, I am wondering ...
1
vote
1answer
40 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
58 views

Availability Group failover stuck in Resolving State

I am setting up a lab for testing automatic failover for SQL Server I have a 2 node WSFC (SQL-CLUSTER-TEST-01) with the nodes SQL-TEST-01 SQL-TEST-02 A listener SQL-HA-GRP-01 My initial testing ...
0
votes
1answer
64 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
27 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 ...
0
votes
1answer
26 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 ...
1
vote
2answers
790 views

Can AlwaysOn cross domains?

Is SQL Server 2014 capable of having AlwaysOn set up across multiple domains? If not, is there a third party tool you can recommend to mirror a 13TB (and growing) database across domains? Thanks in ...
1
vote
1answer
575 views

“Skipping the default startup of database” SQL notification for AlwaysOn Cluster

So I set up our SQL servers to notify us of alerts at severity 17 or higher (as advised by various SQL Server articles). I've done this to each node of a SQL Server Always On Availability Cluster, ...
0
votes
1answer
28 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
0answers
42 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
26 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
259 views

delete WSFC 2012 cluster role/group fails

PS C:\Windows\system32> get-cluster Name ---- sql2012poc_cl1 PS C:\Windows\system32> get-clustergroup Name OwnerNode State ...
0
votes
1answer
40 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 ...
4
votes
2answers
50 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 ...
0
votes
1answer
44 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 ...
5
votes
2answers
169 views

Always On Availability Group, Always redirect user to read only instance

We have an Always On availability group with a primary and a read-enabled secondary. We have a user for the implementation team who uses the database to check the correctness of the data that they are ...
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
51 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 ...
1
vote
2answers
23 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
1answer
23 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 ...
3
votes
1answer
4k views

AlwaysOn Availability Groups go to Resolving status

We have a two-node cluster set up running SQL Server 2012 on Windows Server 2012 R2. The base cluster consists of only those two nodes. The quorum is set up as node + disk majority, with a shared ...
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
vote
3answers
48 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 ...
15
votes
4answers
10k views

SQL Server Agent Jobs and Availability Groups

I'm looking for best practice in dealing with scheduled SQL Server Agent jobs in SQL Server 2012 availability groups. Maybe I missed something, however at the current state I feel that SQL Server ...
1
vote
1answer
47 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
1answer
19 views

Always On -Stand Alones

Can i add a Stand alone instance to a Windows Fail-over Cluster for Always-On Set up. I need to have one secondary Synchronous replica with automatic failover ? Please advice.
2
votes
0answers
750 views

SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy

I have an environment with 2 Windows Server 2012 R2 servers, both with SQL Server 2014 Expensive edition. Whenever a change happens in the AGs (such as: AlwaysOn Availability Groups connection with ...
0
votes
0answers
22 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 ...
0
votes
2answers
32 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.
3
votes
1answer
2k views

Removing secondary replica from SQL Availability Group causes large log file

Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage ...
0
votes
1answer
39 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
43 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 ...
8
votes
3answers
771 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
3answers
477 views

shrink database in always on availability

hi i was using this query for shrinking the database log file USE Tfs_CoE; GO ALTER DATABASE Tfs_CoE SET RECOVERY SIMPLE; GO DBCC SHRINKFILE (Tfs_CoE_Log, 1); GO ALTER DATABASE Tfs_CoE SET RECOVERY ...
-1
votes
0answers
18 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 ...
1
vote
1answer
30 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 ...