All Questions
Tagged with sql-server-2017 clustering
18 questions
0
votes
1
answer
201
views
SQL Server Always On Availability Groups are green, but manual failover attempts consistently failing ("duplicate IP address", etc. in cluster logs)
We're running SQL Server 2017 Enterprise Edition on a pair of EC2 instances (we'll call them "P1" and "P3" here) in AWS. Each EC2 instance is in its own subnet, and runs two ...
0
votes
0
answers
102
views
Procedures to safely perform SQL Server Always On database cluster failover during Updates & Patching?
I need some steps and guidance, to perform the Microsoft Cluster Failover (MSCS 2016) for my SQL Server 2017 Enterprise Edition – Always-On 2x nodes.
This is to perform the Windows Server updates that ...
0
votes
0
answers
90
views
SQL Cluster (Always On) - Database table replication
I have the following scenario at this moment.
Two old sql servers - they have setup some kind of publisher subscriber replication from one database to another but only some of the tables at a 12 hour ...
0
votes
1
answer
160
views
How to do failover between AG setup for FCI-FCI servers
Hope I can portrait my question well because i really get confused with AG's :)
We have the setup like below-
Windows cluster WKCLU01 with 4 nodes (Node1,2,3,4) and a file share witness in DC3, total ...
- 794
1
vote
1
answer
848
views
Multi-instance 2-node SQL Cluster - do instances need their own disks?
I currently have a single default instance of SQL2017 Standard on a 2-node cluster.
Against my preference, I need to setup a second instance on the cluster (the new database requires some users to ...
- 51
-2
votes
1
answer
144
views
Can't create availability group , big error message
hello I am setting up my "high availability group" and I have a little problem, I have this error message .
maybe I have to validate my cluster first? I already tried to validate but I also receive ...
0
votes
0
answers
54
views
Query on SQL HA/DR
DC1: we have two DB servers (DB1 and DB2) on top of WSFC
DC2: 1 DB server (standalone DB machine).
I have configured SQL Always-On on DC1 from DB1 to DB2. Now I have to sync/replicate data from DC1-...
- 65
0
votes
2
answers
72
views
Query on SQL Server Always On
DC1: (servers are in WSFC): DB_Server1 and DB_Server2
DC2: DB_Server3
DC1 and DC2 servers are located in different geo locations. Is it possible to configure SQL 2017 Always-On/SQL 2017 Distributed ...
- 65
4
votes
2
answers
254
views
SQL Server 2017 Distributed Availability Groups
My Environment is SQL Server 2017 Distributed Availability Groups, details as follows:
Configured SQL Distributed AG from DC1 to DC2.
DC1 (Production): TEMPDB1 AND TEMPDB2 (HOSTED ON WSFC1)
DC2 (DR)...
- 65
4
votes
1
answer
14k
views
DATABASE lacks a quorum of nodes for high availability
Just after setting up successfully alwayson - availability group,
testing the failover,
I get this error message:
TITLE: Microsoft SQL Server Management Studio
Failed to resume data movement in ...
- 16.6k
3
votes
1
answer
780
views
Database Engine and SSISDB architecture advice
I'm seeking some architecture advice involving the database engine and Integration Services components of SQL Server 2017. We have an existing SQL Server environment which is due for an upgrade and ...
0
votes
1
answer
60
views
Can a query whose execution plan uses parallelization use the cores of a processor on a another server that's part of the same Availability Group?
If I have two servers (server A and server B) that are part of the same Availability Group failover cluster, and a query running on server A has an execution plan that uses parallelization, is it ...
- 39.5k
1
vote
2
answers
241
views
Upgrade SQL Server 2014 AG to SQL Server 2017 AG
Is it possible to migrate SQL Server 2014 AG (Windows 2012, SQL Server 2014) to SQL Server 2017 AG (Windows 2016, SQL Server 2017) using rolling upgrade method?
What I mean is
Build 2 SQL Server ...
- 673
3
votes
2
answers
10k
views
Why am I unable to create this Availability Group? (error 35220)
I was attempting to create an Availability Group on a SQL Server 2017 instance and was running into error 35220:
Could not process the operation. Always On Availability Groups replica
manager is ...
- 201
1
vote
1
answer
208
views
AG of 2 replicas on 2 nodes in WSFC : is it possible to add 3rd replica to AG and NOT add 3rd machine WSFC?
Please help to to research the possibility of below:
We have availability group that consists of two replicas:
replica 1: SQL Server 2017 on Windows Server 2016
replica 2: SQL Server 2017 on ...
- 5,964
2
votes
0
answers
335
views
SQL Server 2017 Failover Cluster on RHEL Linux
I am trying to create Failover Cluster on SQL Server 2017 on RHEL 7.3 Linux, following this document from Microsoft:
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-shared-disk-cluster-...
- 397
2
votes
1
answer
3k
views
Upgraded to SQL Server 2017 and now see WSFC lease timeouts
I recently upgraded a production DB environment from SQL Server 2016 Standard Edition to 2017 Enterprise Edition (CU3). We used a Basic Availability Group when on Standard Edition and recreated the AG'...
- 23
1
vote
3
answers
2k
views
Can you run two WSFC instances on two servers where each node is the primary for a different availability group?
I'm drawing up a proposal for upcoming infrastructure changes. This will include a production server and reports/data warehouse server, each with Always On. To keep hardware and licencing costs down, ...
- 758