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.
429
questions
0
votes
0
answers
15
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
-1
votes
0
answers
23
views
for MS SQL in EC2 need a solution that the user can perform any admin activity but it should not able to query any data from tables [duplicate]
We have MSSQL DB in EC2, where we are using generic user (Active Directory User) for SQL to perform any activity inside the server.
This user requires to perform all admin tasks .But, as xyz being ...
- 1
0
votes
0
answers
66
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
60
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
171
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
93
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
109
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
69
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
79
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
393
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/...
- 322
0
votes
1
answer
194
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 ...
- 133
0
votes
0
answers
546
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
46
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 ...
0
votes
1
answer
810
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
1k
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
59
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
54
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
138
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
584
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
389
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
886
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
1k
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
145
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
853
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).
...
- 11
1
vote
0
answers
176
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
604
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,078
0
votes
1
answer
896
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,078
0
votes
0
answers
155
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
8k
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 ...
- 41
0
votes
2
answers
262
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
111
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 ...
- 1,999
0
votes
1
answer
434
views
SQL server resets UDP port 1434 connections
Attempting to connect to a named instance on SQL server.
Attempt is made in port 1434 (SQL Browser)
PCap shows the connection acknowledged and reset.
SQL Browser service is running
TCP/UDP port 1434 ...
- 1
0
votes
1
answer
194
views
SSRS migration with Same Name and Moving of Reporting Files
This is will be my first SSRS migration and please bear with me if some points don’t make any sense.
I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’...
- 1,019
0
votes
0
answers
479
views
How to schedule a job using windows task scheduler to export data from potgresql eriodically into CSV file.?
I am facing an issue even after following all the steps as suggested in the answer provided by Neil Mcguigan for the question asked In the above link
I was getting an error - "psql: f_sendauth no ...
- 1
0
votes
1
answer
294
views
How to create SQL Server backup from Windows Server to Linux Client with SQLCMD?
I've got sqlcmd installed on an Ubuntu LTS instance and I'm able to connect successfully to Windows SQL Server and do queries and such.
sqlcmd -S 192.168.0.100 -U SA -P secret
I need to be able to ...
- 101
1
vote
0
answers
60
views
Testing SQL connections with UDL file
I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
- 75
0
votes
1
answer
104
views
Windows 2008 R2: Unable to upgrade MySQL 5.5.58
We have MySQL 5.5.58 sitting on a Windows 2008 R2 box.
I have downloaded the Installer from https://dev.mysql.com/downloads/mysql/ but nothing happens when I try and upgrade.
At the installer screen, ...
- 194
1
vote
4
answers
408
views
Does restarting Windows restart the SQL Server?
Doesn't restarting Windows also restart the SQL Server?
Long story is that I just made the change so that both SQL Server and Windows authenticated users can log in. The server needs a restart for the ...
- 23
1
vote
1
answer
327
views
DBCC Check DB fails due to operating system error 665
We have a SQL Server 2017 Standard version where recently the CHECKDB is failing with the operating system error 665.
The fragmentation level of the disk drive is 0% as it is automatically ...
- 1,019
0
votes
1
answer
77
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 ...
- 63
0
votes
1
answer
403
views
The Windows Server Failover Clustering (WSFC) resource control API returned error code 19
What is root cause of this error. I couldn't find any related information.
There are two nodes on Availability Group and if you reboot second node, database wont up.
0
votes
1
answer
269
views
MySQL on Windows Refuses to Start as a Service
I am trying to install MySQL 5.7.33 onto a windows 2012 server. A process I have done many many times.
I have copied the Zip file onto the server and expanded it into G:/mysql57/ (the same zip file I ...
- 2,046
1
vote
1
answer
653
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 ...
- 495
0
votes
1
answer
391
views
SQL Server License Migration [closed]
We need to move our SQL Server 2016 standard License. Our plan is to install SQL Server on the new box with the same license key , test the application / databases and then delete the old SQL server ...
- 1,019
0
votes
0
answers
171
views
Oracle 12cR2 - Upgrade Catalog Command Taking Too Much Time
I patched my database (Windows database bundle patch 12.2.0.1.201020 (31654782)).
There are 6 instances on the server. After the patch, the UPGRADE CATALOG command I ran on RMAN for the first 5 ...
- 29
0
votes
1
answer
182
views
High Latch Wait time with Logon trigger enabled while full backups are running
I have 14 production servers with SQL 2016 standard version, 128 gb of RAM, 16 CPU and SSD drives.
Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64) Oct 31 2020 02:43:57 ...
- 1,999
1
vote
0
answers
333
views
What are the available automatic failover solutions for MariaDB Master-Slave replication on Windows Server?
I am setting up a Master-Slave or Master-Master setup in MariaDB on two seperate servers running Windows Server. I also need to configure an automatic failover solution where client read requests gets ...
- 11
0
votes
1
answer
703
views
local administrator does not have permissions to create database in db2
I have a fresh standard installation of DB2 11.5 on Windows server 2016. According to documentation, i need the to have SYSADM or SYSCTRL to create a new Database.
The documentation for "...
- 312
0
votes
3
answers
71
views
How can I make queries secret?
I have a project whose activity I need to keep private, and I'm not the server administrator.
If my app updates a value for the user with id 1, it would probably say something like UPDATE 'users' SET '...
- 111
4
votes
3
answers
2k
views
SQL Server - Benefits of splitting databases across different logical drives
We're about to start a project to migrate a large DWH to new physical servers in a new data centre. The current server spec is SQL Server Enterprise 2016 SP2 running on Windows 2012 R2. The new ...
- 326