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.
446
questions
0
votes
2
answers
106
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
56
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
104
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
50
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
38
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
95
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
32
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
153
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
2k
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
102
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
829
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 + ...
- 69
2
votes
1
answer
192
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
0
votes
0
answers
12
views
Oracle 10.2.0.4 instance won't load after system reboot on Windows 2012 R2 server
I know it's prehistoric software but I have some legacy apps that require it.
When installing Oracle database 10.2.0.4 on a Windows 2012 R2 server 64 bit system everything works perfectly until I ...
- 1
1
vote
1
answer
2k
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
20
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 ...
