No announcements
-
3 VotesWelcome to the SQL Server Disaster Recovery and Availability Forum
(Edited 8/14/2009 to correct links - Paul) Hello everyone and welcome to the SQL Server Disaster Recovery and Availability forum. The goal of this Forum is to offer a gathering ...Sticky | 5 Replies | 68555 Views | Created by Paul Randal - Saturday, June 3, 2006 4:25 PM | Last reply by Markwillium - Friday, February 22, 2013 6:34 AM
-
0 Votes
sp_server_diagnostics running in 2 SPID's on Primary Server
Hello, I have three servers in an Availability group. On the primary server I see 2 SPID's ...Proposed | 8 Replies | 196 Views | Created by TravisJB - Thursday, December 26, 2019 5:03 PM | Last reply by Liweiyin - Friday, December 27, 2019 9:50 PM -
0 Votes
Why automatic failover doen't happened on from Node 2 - node 1 ,2-Node cluster , sql / windows server 2016
Hello Team, System OS : Windows Server 2016 Standard Physical server /on-premises / 2-node cluster ...Proposed | 7 Replies | 396 Views | Created by swatsaswath - Friday, December 20, 2019 3:56 PM | Last reply by Hemantgiri Goswami - Friday, December 27, 2019 12:00 PM -
0 Votes
AlwaysOn endpoint slows down.
In a two node, SQL AlwaysOn cluster with synchronous replication, we have seen the following problems periodically: • Initial sync of a new added database with automatic ...Unanswered | 4 Replies | 384 Views | Created by juniorkiran - Tuesday, December 17, 2019 1:24 PM | Last reply by juniorkiran - Wednesday, December 25, 2019 11:51 AM -
0 Votes
Too many items to match in SQL query
Hi there, I have this script that I am trying to run but I have found that it will be difficult to write it This is what the script looks ...Proposed | 3 Replies | 200 Views | Created by RayRay_dba - Tuesday, December 24, 2019 6:11 AM | Last reply by Stan210 - Tuesday, December 24, 2019 3:26 PM -
0 Votes
Connection AlwaysOnListener with ReadOnly
Hello, There is connection failed error while connecting AlwaysOnListener with ReadOnly. But connecting to secondary server is ...Proposed | 5 Replies | 340 Views | Created by Revane Selimova - Friday, December 20, 2019 1:49 PM | Last reply by Cathy Ji - Tuesday, December 24, 2019 10:17 AM -
4 Votes
AlwaysOn should have quorum disk configured?
Hi All, I am new to SQLServer2014 Always on. I had a doubt, Is AlwaysOn should have quorum disk configured? Thanks in ...Proposed | 5 Replies | 1173 Views | Created by JPSQL - Wednesday, December 4, 2019 12:19 PM | Last reply by Cris Zhan - Monday, December 23, 2019 9:38 AM -
0 Votes
ILB configuration for windows failover clustered instance (2-node, 4 instances)
Hi all, I have configured a 2 node windows failover cluster having 4 instances in it in Azure VMs. I have also configured an Azure ...Unanswered | 8 Replies | 762 Views | Created by Yasir789 - Wednesday, December 11, 2019 6:40 AM | Last reply by Gonzalo Bissio - Wednesday, December 18, 2019 3:25 PM -
0 Votes
Configuring Always On with mixed public/private network
Hi all, I need to setup AG ...Proposed | 6 Replies | 750 Views | Created by Leila S - Monday, December 16, 2019 10:29 AM | Last reply by Leila S - Wednesday, December 18, 2019 12:47 PM -
0 Votes
Differential Backup fails in SQL Server Failover Cluster Enviornment
Hello, I have setup Failover cluster on SQL Server 2014 which working fine. Then I implement backup strategy. It is also working fine. But after failover only ...Answered | 13 Replies | 1712 Views | Created by AK9841 - Wednesday, September 7, 2016 10:28 AM | Last reply by Electropote - Wednesday, December 18, 2019 9:51 AM -
0 Votes
Log Shipping False Alert for Job Fails
Dear Team, We have noticed in SQL Log that we are getting a false alert every 15 min (we are using Log Shipping for other SQL Database), we found that the meta data related to the ...Answered | 7 Replies | 434 Views | Created by ITCVinod - Tuesday, December 17, 2019 8:17 AM | Last reply by Amelia Gu - Wednesday, December 18, 2019 7:19 AM -
0 Votes
AlwaysOn cluster node3 show current vote= 0
I have configured Alwayson with 3 Node (Node1, Node2 and Node3) with Witness file share quorum. I'm not really sure about this why node3 is show ...Answered | 2 Replies | 467 Views | Created by Baraiya Kirit - Thursday, December 12, 2019 9:42 AM | Last reply by Sean Gallardy - Tuesday, December 17, 2019 1:57 AM -
0 Votes
Availability Group Listener Setup
I have two servers running SQL Server 2016 on Windows Server 2016. Server 1 Private IP: 10.80.237.213 VLAN 886 Server 2 Private IP: 10.187.96.51 VLAN ...Answered | 3 Replies | 834 Views | Created by CJ Bosley - Friday, December 13, 2019 7:11 AM | Last reply by Cathy Ji - Monday, December 16, 2019 6:31 AM -
0 Votes
Synchronize Availability Group Logins
Security->Logins are missing on one server. Is there way to sync DBINSTANCE->Security->Logins to replication as well. I have seen few script is available on net that ...Proposed | 3 Replies | 700 Views | Created by Zeeshan.Butt - Thursday, December 12, 2019 11:23 AM | Last reply by Hilary Cotter - Thursday, December 12, 2019 3:10 PM -
1 Votes
sync between the AlwaysOn HA SQL Servers in the HAG fails or is in the paused state on the secondary server
SQL Systems run fine and the next day the sync between the AlwaysOn HA SQL Servers in the HAG fails or is in the paused state on the secondary server for most of the ...Unanswered | 8 Replies | 1335 Views | Created by juniorkiran - Saturday, December 7, 2019 8:53 AM | Last reply by Cris Zhan - Wednesday, December 11, 2019 8:54 AM -
1 Votes
not able to failover with listener configured
Hi All, I am new to SQL Server 2014 Availability group. I have created Availability group followed the below ...Proposed | 3 Replies | 1069 Views | Created by JPSQL - Thursday, December 5, 2019 2:54 AM | Last reply by Cris Zhan - Tuesday, December 10, 2019 6:55 AM -
0 Votes
2 Node VM Cluster
Hi, I need to create a two node SQL 2014 HA Cluster on two Windows 2016 Hyper-V VMs with HP SAN Storage. I have created separate LUNs for both the VMs like below. Is it the correct ...Unanswered | 5 Replies | 1423 Views | Created by create_share - Wednesday, November 27, 2019 3:41 AM | Last reply by Shanky_621 - Tuesday, December 10, 2019 5:20 AM -
0 Votes
Full Text index is not working in MSSQL 2016 Express
One of my application is using "Always on availability groups". When failover happens, it picks the secondary server, but in secondary server Full text index is not working .If the secondary ...Proposed | 3 Replies | 778 Views | Created by Aviz Ziva - Friday, December 6, 2019 11:22 AM | Last reply by Cathy Ji - Monday, December 9, 2019 7:29 AM -
0 Votes
SQL Server 2012 running on WSFC...Add SQL 2016 Instance/Role
We currently have a 4 Node Windows 2012 R2 Failover Cluster running 4 different SQL 2012 Roles/SQl Instances, they each have their own Storage blob and IP ...Proposed | 3 Replies | 875 Views | Created by Jeromey Balkey - Friday, December 6, 2019 1:09 AM | Last reply by Amelia Gu - Monday, December 9, 2019 2:25 AM -
3 Votes
How to get information about an AG group using powershell
Hi Experts, Does anyone has a powershell script which displays below information: for a given AG listener name or AG group name, I need to ...Answered | 3 Replies | 989 Views | Created by Samantha v - Saturday, December 7, 2019 10:40 AM | Last reply by Samantha v - Sunday, December 8, 2019 2:24 PM -
0 Votes
3-node multi-subnet FCI+AG issue with CSVs
I'm working on setting up a 3 node multi-subnet FCI+AG solution with two FCI nodes in the primary data center on one subnet, and a third node with a standalone SQL instance on another subnet for ...Proposed | 5 Replies | 846 Views | Created by kjm76 - Thursday, December 5, 2019 10:12 PM | Last reply by Edwin M Sarmiento - Friday, December 6, 2019 8:23 PM - Items 1 to 20 of 9465 Next ›
No announcements
