People who code: we want your input. Take the Survey

Questions tagged [windows-server-2019]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
9 views

ORA-12631 using Database Links with Oracle DBMS 19c on Windows Server 2019

We had a set of long-time Oracle 12c Database installations (multiple instances on separate VMs) on Windows Server. Over the past year we transitioned to Oracle 19c on Windows Server 2019. We found ...
0
votes
0answers
38 views

Postgresql logical replication reapeted failures, replication slot is active for PID x

Postgres 13.2 running on Windows server 2019. Every few days or sometimes even more frequently logical replication is stopped by an error replication slot "sbscr_name" is active for PID 4754 ...
4
votes
1answer
238 views

No parallelism in Express Edition of SQL Server

I have SQL Server 2019 Express Edition (CU8) on Windows Server 2019 (1809 version) and all of my queries go serial with NoParallelPlansInDesktopOrExpressEdition in NoparallelPlanReason property. Is it ...
0
votes
1answer
20 views

Upgrading Operating System only. OS 2016 - 2019

Currently we have a number of Servers that are using Windows 2016 with SQL Server 2017. The support team want to do an in-place upgrade of the OS to 2019 due to 2016 Mainstream support ending in Jan ...
1
vote
1answer
102 views

SQL Server Cluster and Windows Server Storage Replication

I am currently investigating on how to setup a SQL Server stretch cluster in combination with storage replication for which I want to use Windows Server Storage Replication. However, I am no sure on ...
-1
votes
3answers
354 views

DNN Listener resolving to a secondary server in WSFC & AO AG

I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019 CU8): A - Subnet 1 - Principal Server (Sync) B - Subnet 1 - Secondary Server (Sync) C - Subnet 2 - Secondary Server (...
0
votes
0answers
22 views

SQL Server HA Design (FCI) - Windows Storage Replication - Test-SRTopology - Physical Memory Error - AWS EC2

I'm trying to set up AlwaysOn Failover Cluster Instance (Not Availability Groups) on 2 VMs(each on different AWS Availability Zone) in AWS-EC2 instances. To make this happen, I've to set up Windows ...
0
votes
2answers
97 views

Windows Server 2019 and SQL Server Backups issue?

I have an issue with SQL Server that is really driving me nuts so I wanted to ask if anyone has any suggestions. I have a program that does a daily backup of the SQL Server database. This has worked ...
0
votes
1answer
25 views

Windows Server 2019 non-owner node cannot see Cluster Name or IP

I am trying to build a SQL Server AlwaysOn Availability Group with 2 nodes in Azure. I have created 2 SQL Server VMs and Managed to create a Cluster with both Nodes as members of that cluster.  I ...
0
votes
2answers
512 views

SQL Server 2019 Always On using Distributed Network Name

We're running a couple SQL servers in Azure that are set up with an Always On availability group and Windows Failover Clustering. The servers are Windows 2019 and we're running SQL Server 2019. When ...
1
vote
0answers
51 views

Keep 2 instances of SQL Server synced [closed]

We want to set up a second instance/server of SQL Server such that both instances will be kept in sync. The reason is we need to separate some users and processes out to a separate server for business ...
2
votes
0answers
255 views

SQL Browser Service Stops After One Minute

I am encountering an issue with the SQL Browser service where the service will start, run for around 60-90 seconds and then stop. No error is logged, the event logs show three informational entries: ...