Questions tagged [windows-server]
All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.
448 questions
0
votes
1
answer
32
views
MariaDB - Is it safe to delete a large temporary file?
I am running MariaDB on a Windows Server 2022 Standard and I am running out of disk space on the system disk.
I have found a file named ib534F.tmp with 65 GB related to MariaDB in the path:
C:\Windows\...
- 3
1
vote
1
answer
37
views
Stop AlwaysOn service and SQL Server
I have an AlwaysOn configuration with 3 servers, two of them in synchronous mode with two Availability Groups, and the third server is in asynchronous mode because it is located in a remote site.
Due ...
- 169
0
votes
1
answer
73
views
How to Configure SSRS Web Service URL and Web Portal URL via Command Line
I need to apply the default settings on SSRS Web Service URL and Web Portal URL, but i need to do it automatically somehow.
Is it possible to do it via command line?
I have looked through this SSRS ...
- 1
0
votes
2
answers
143
views
SQL Server database size is 10GB but tables are only around 450MB, what is occupying the rest and how can I reduce it?
I have a SQL Server database that has reached the 10 GB limit.
When I do use EXEC sp_spaceused, I get
reserved
data
index_size
unused
10483208 KB
10352336 KB
90264 KB
40608 KB
However when I do ...
- 3
0
votes
1
answer
66
views
which db consume more core from my computer
I have several db in my instance in SQL Server. I wonder which db consume more core from my computer.
How to find this information?
- 57
0
votes
2
answers
131
views
What is taking backups of my servers?
I am working in virtualized environment. All my SQL instances are hosted on Windows Server machines. My infrastructure team is using Veeam tools for backups and replication to the secondary data ...
- 192
0
votes
0
answers
64
views
AG Listener goes offline during comms link failure
I wanted to try and get some clarity on some behavior we recently experienced with a number of our production clusters during an event where we lost both communication links.
Ours clusters span two ...
- 53
0
votes
0
answers
47
views
Scheduled task in windows server does not appear in PostgreSQL log file
PostgreSQL 14 - Windows Server 2012
I have a scheduled task every day at 5 AM. It executes an sql file with an update query and some refresh materialized views.
According to Windows Server, the task ...
- 207
0
votes
2
answers
178
views
Shift Installation of PostgreSQL 15 from one hard drive to another in window server
I have a PostgreSQL database installed on one of my four hard drives in a Windows Server 2012 R2 machine. I would like to move the database, along with all of its configurations, to another drive ...
- 1
0
votes
0
answers
43
views
SQL Server 2014 extended stored procedure gets stuck after Windows Server 2012 R2 updates
After running Windows Server updates (including server restart), SQL Server experienced problems executing XP_ commands. These are stuck forever without any response. The only solution I have found so ...
- 1
0
votes
1
answer
228
views
Windows Power Plans for SQL Server
Is the High Performance power plan in Windows Server still relevant in SQL Server setups on modern hardware/virtualization? Searching for articles from my usual trusted sources brought up nothing more ...
0
votes
1
answer
3k
views
[ODBC SQL Server Driver][DBNETLIB] SSL Security Error - Windows 2003 App Server to Remote SQL Server 2022 Connection
We have migrated the application databases from an old SQL Server 2000 instance running on Windows 2003 to a new SQL Server 2022 instance running on Windows 2022. The application tier has a number of ...
- 652
0
votes
1
answer
143
views
Joining SQL 2016 to a one-node cluster that has SQL 2014 installed
I have currently 1-node (it's a lab) Windows 2012R2 cluster with SQL server 2014 installed (patched to the last patch based on sqlserverupdates.com). The goal is to upgrade the cluster
to something ...
- 360
0
votes
2
answers
1k
views
Adding a Windows Server 2016 computer to a Windows Server 2022 Failover cluster
Is it possible to join a Windows Server 2016 computer to an existing Windows Server 2022 2-node Failover cluster? The cluster is domain-independent.
Hypothetical setup:
Node 1 (windows server 2022 + ...
- 79
2
votes
1
answer
220
views
MariaDB 11.0 to 11.1 GA fails with ERROR 1210 (HY000) at line 32: Incorrect arguments to DATA DIRECTORY
I upgraded to MariaDB 11 some time ago, and all has been working well for a long time. I saw there was a newer GA release, 11.1, so decided to update to that, but the upgrade fails. This is on Windows ...
- 41
1
vote
1
answer
3k
views
No connection possible after TrustServerCertificate=True => The certificate chain was issued by an authority that is not trusted
I have a machine which could connect to an MS SQL Server in the past. I have SSMS installed and the connection was possible when I activated TrustServerCertificate checkbox in SSMS. I could connect ...
0
votes
1
answer
21
views
On which node must the failover manager for the AG be?
I have an availability group for Windows SQL Server. It is so that instances hosting replicas must be in a Windows failover cluster. However, if the node where the failover manager is on fails, what ...
0
votes
1
answer
138
views
Tune SQL Server 2019 for receive many small queries
I am using SQL Server SE 2019, on a Windows Server 2019 (with SSD drive) that run IIS 10. On top of IIS 10 run an ASP.Net application, that has to be considered AS IS (I can't modify it).
Lately tourn ...
- 368
0
votes
0
answers
278
views
SQL Database not working after OS upgrade
Let me begin by saying I’m a noob with anything SQL.
So I was tasked to upgrade the OS on a VM running Server 2012 R2 with SQL Server 2014 Services running on it. Mainly, there is an internal website ...
- 1
3
votes
1
answer
320
views
Upgrading out of support Microsoft SQL instance multiple questions?
I just got a new job as an analyst but I’m being tasked with an administrator task and just looking for insight.
We have a Windows server 2003 (32bit) that has Microsoft SQL Server 2005. I have been ...
- 31
0
votes
1
answer
54
views
How to monitor mysql master - slave replication in windows os and failover in event of failure of master
I have a master and 3 slave all on windows OS.
I need a tool I can use to monitor replication and failover to a slave incase the master is goes down. What tool do you recommend.
I prefer open source ...
- 1
0
votes
0
answers
1k
views
Postgresql logical replication suddenly stop (wal status is extended, An existing connection was forcibly closed by the remote host)
I checked the replication status of our production server when i noticed that one of the replicated DB is missing (using pg_stat_replication command).
I also check the replication slots and found out ...
1
vote
0
answers
90
views
BCP to SQL Server DB seeing excessive waits
I have a process I built in Powershell which has been working flawlessly for years on a couple servers, but when I migrate it to new servers I see a lot of waits (ASYNC_NETWORK_IO) during BCP step ...
- 11
0
votes
0
answers
541
views
SQL Server High Availability Windows Cluster - DNS Records are deleted after failover
We an an issue were when we failover a sql server clustered instance sometimes the server fqn servername.domain.com DNS Host A record entry will disappear. Has anyone had this issue and a fix?
...
0
votes
0
answers
258
views
Connection String requires AttachDbFilename property
I'm trying to use SQL Server LocalDb to store the database by connection string. During first connection to the database I have an error about connecting to the database. In SSMS it is opening. To fix ...
0
votes
0
answers
165
views
Windows server localdb issue
I'm trying to deploy a database to a Windows Server machine.
The database is a SQL Server LocalDB. When I deploy it to a Windows machine, everything works correctly. When I try to deploy the same ...
0
votes
0
answers
77
views
Create logins for all active directories groups named ("Domain Users"), related to current Windows Authenticated user in SQL Server
I need to get all active directories locations, related to current machine, by SQL script to create logins for them. Is there a way to perform that? For now I wrote such procedure:
USE [master]
GO
...
1
vote
0
answers
216
views
User Permissions for WAL files
I'm setting up replication on Postgres. (expect more questions later :-)
I'm putting the WAL files on the NAS so that both servers have access to the files.
The Postgres service is running as "...
- 111
0
votes
1
answer
2k
views
pg_restore error when using the --single-transaction: options c/--clean and -a/--data-only cannot be used together (even so the -a flag was not used)
I met a strange PostgreSQL (v.13.8) on a Windows server 2019 machine today when trying to restore a custom dump file.
The following command worked:
pg_restore -d postgres://postgres@localhost:5432/...
- 384
0
votes
1
answer
538
views
WSFC Dynamic Quorum not removing votes
Environment is Windows Server 2019 in Azure
I have a 3 node multi-region cluster.
Server 1 & 2 are in the same region while server 3 is in a remote region.
Server 3 does not have a vote in the ...
- 371
0
votes
0
answers
2k
views
What can cause cyclical CPU spikes on a SQL Server precisely every 5min
Setup
Microsoft SQL Server 2008 on Windows Server 2008 (Yes I know I need to upgrade).
The server is accessed by a single Linux/Apache web server.
Problem
Starting about a week ago and slowly getting ...
- 343
0
votes
1
answer
70
views
Dell Server Raid 1 drive quick replacement with 2 exact copies
Apologies if I am posting this to the wrong place.
We are unfortunately having to handle our own server administration in-house and no one here is an expert at servers in any way! (we are web app ...
-3
votes
1
answer
3k
views
What is the difference between CU-GDR and GDR?
There are 2 paths to patching SQL server. Either the SQL CU (cumulative) upgrade or GDR (critical) upgrade.
CU includes functionality fixes and security fixes (https://support.microsoft.com/en-us/...
- 1
0
votes
1
answer
3k
views
This operation returned because the timeout period expired - unable to add third node to existing Windows Failover Cluster
I have a Windows failover cluster up and running, with two nodes.
I'm now trying to add a third node:
Add-ClusterNode -Name node3
this unfortunately fails with the following error:
The clustered ...
- 113
1
vote
2
answers
88
views
Reinstalling server and SQL Server database
Due to some Windows issue, can't clean-up the WinSxS folder and the Disk Space process (cleanmgr.exe) makes the CPU going to 100% meaning that I am at 97% of disk usage, I am planning to reinstall the ...
- 111
0
votes
0
answers
104
views
Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings
I need to 'swap' an old database server (Windows Server 2008, SQL Server 2005) with a newer/better one (Windows Server 2012, SQL Server 2008) I tested this swap yesterday and everything worked on the ...
- 629
0
votes
1
answer
268
views
Software to help automate windows os patching with SQL Server high availability/failover clusters [closed]
is there a third party tool or a way to automate installing windows updates on windows clusters with sql server high availability groups installed? right now we have a manual process of installing ...
1
vote
2
answers
945
views
Performance of the same MySQL database is different on different servers
I have two servers:
Server A: AMD Epyc 7371 - 16c / 32t - 3.1 GHz / 3.8 GHz 256 GB ECC 2400 MHz 2 × 960 GB NVMe SSD MySql 8.0.26
Server B: Dual Intel Xeon Gold 6242R - 20c / 40t - 3.1 GHz / 4.1 GHz ...
0
votes
0
answers
741
views
Postgresql as clustered role in Windows Failover Cluster
I am looking to implement a Highly available postgres cluster with automatic failover in a 2 node Windows cluster.
Can we configure it similar to active passive SQL Server FCI with shared storage ...
4
votes
1
answer
2k
views
Microsoft SQL server storage best practice on Windows server vm with hybrid storage
I have a windows server VM, with a combination of HDD and SSD storage, the SSD storage capacity is limited to 50 GB, but HDD storage capacity is high.
What is the best way to share these storages to ...
- 251
0
votes
0
answers
3k
views
SQL Server Launchpad Service keeps shutting down
We have a problem with the Launchpad Service shutting down and doesn't come back up. The service is has startup type "automatic", but when the server is restarted, or the sevice is stopped ...
- 101
0
votes
1
answer
175
views
SQL Server Access Database in Filesystem
We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server.
This server used to host an SQL ...
- 177
0
votes
1
answer
3k
views
ORA-12152: TNS: unable to send break message - Only LISTENER restart works
i have a strange problem with our Oracle 12.1.0.1.0 on our VM Windows Server 2016.
I create a daily batch script whichs creates a dump file (via EXP) and execute some sql statements (via SQLPlus).
...
- 21
1
vote
0
answers
376
views
Windows Suspending PostgreSQL Process
Scenario:
Customer’s system
VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors)
PostgreSQL starts and runs fine for 5 minutes - 2 ...
- 121
1
vote
1
answer
1k
views
SQL Server 2017 AlwaysOn Failover Cluster issue
I have 2 Windows 2012R2 VM's running on Vmware ESXi 7 with VMDK's as the SQL disks.
I have a SQL 2017 AlwaysOn Cluster running on Server 2012R2.
there is no any running backup (SNAPSHOT)
PROD : 10....
- 1,106
0
votes
1
answer
2k
views
Intermittently failover of my SQL Server resources on Windows Server 2016
I have 2 Windows 2016 VM's running on Vmware ESXi VMware ESXi, 6.7.0, 17700523 with VMDK's as the SQL disks.
I have a SQL 2017 AlwaysOn Cluster running on Server 2016.
Basically everything is pointing ...
- 1,106
0
votes
0
answers
245
views
mysql takes too long to restart (Large Database)
I have a large db ( >20gb ). and since the maintenance downtime by our service provider this morning, I had tried to start the mysql but its been 7 hours. then I kill the service using task manager ...
- 1
4
votes
2
answers
13k
views
Cannot install Sql Server 2019 on Windows Server 2022
On a brand new install of Windows Server 2022 standard, I am trying to install SQL Server 2019.
I downloaded the eval version, put my key in and proceeded to install the Database Engine. Default ...
- 43
0
votes
2
answers
497
views
Always On Failover Cluster Instances (FCI) on existing SQL Server
I have launched three EC2 Windows_Server-2019_SQL_2019_Standard instances. How can I implement Always On Failover Cluster Instances (FCI) on these existing SQL Servers. I can only find details like ...
3
votes
0
answers
124
views
SQL Server should I format with ReFS to get rid of operating system error 665? [duplicate]
I have 13 production SQL Servers
Microsoft SQL Server 2016 (SP2-CU11) (KB4527378) - 13.0.5598.27 (X64) Nov 27 2019 18:09:22 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on ...
- 2,039