Questions tagged [windows-server-2022]
10 questions
3
votes
0 answers
Enable COPY_ONLY Backup Via DISKSHADOW Command Prompt
Introduction
I'm experiencing weird behaviour on a virtualised (ESXi) Windows Server 2022 running SQL Server 2019 when the VMware conducts a snapshot of the server. It doesn't log the snapshot in the msdb database.
On all our other SQL Server 2019…
John K. N.
- 18,854
- 14
- 56
- 117
2
votes
0 answers
SQL Server could not register the Service Principal Name (SPN) ... without membership in Domain Admins
A separate domain account was created for the database engine service of a SQL Server Failover Cluster Instance. Server Principal Names (SPNs) were added manually via the SetSPN.exe command line tool.
If the domain account for the database engine…
Dave Mason
- 875
- 1
- 8
- 19
0
votes
1 answer
Cluster Error 1069 and 1205
I have just built a SQL Server 2022 Always on Availability group with 3 Nodes at HQ and 1 Node at DR.
During our testing phase I have noticed every time I rebooted the primary without failing over or moving the cluster resources from the primary I…
SQL_NoExpert
- 1,107
- 1
- 21
- 37
0
votes
0 answers
SQL Server RML Utilities - installation on Windows Server 2022
Trying to run the RML Utilities on Windows Server 2022 & this is listed as compatible but when I run readtrace getting error 0x80040154 & the connection to the db server fails, which seems to be due to I haven't installed the extra componenents…
Stephen Morris - Mo64
- 4,656
- 1
- 10
- 18
0
votes
0 answers
MySQL 8.4 out of memory
We have an instance of MySQL 8.4 running on Windows Server 2022. It ran fine for 12 days, but suddenly it is consuming a lot of memory. I've deducted this from the Windows Event log and the MySQL error log.
Example: (MySQL error log) [ERROR]…
VITSupport
- 1
- 1
0
votes
1 answer
MySQL 8.4 out of memory
We have an instance of MySQL 8.4 running on Windows Server 2022. It ran fine for 12 days, but suddenly it is consuming a lot of memory. I've deducted this from the Windows Event log and the MySQL error log.
Example: (MySQL error log) [ERROR]…
VITSupport
- 1
- 1
0
votes
1 answer
automating backups to S3 with SQL Server 2022
Not a DBA so please bear with me.
I have an EC2 instance running SQL Server 2022 and I'm trying to automate database backups to S3 using the native S3 connector in this version of SQL Server. The underlying infrastructure is there - I have the…
noctred
- 3
- 1
0
votes
0 answers
How to replicate postgresql 11 database to a second local drive
I have a number of issues in a PostgreSQL 11 database.
I'm very close to filling the 2TB data drive but I'm not able to "grow" the drive
I'm finding it very difficult to reduce the size of the database by removing old data from the two very large…
fluffy_mart
- 11
- 2
0
votes
1 answer
Can I run a second server on a Virtual Machine on my original physical server, or do I need to run 2 Virtual Machines to have 2 servers?
The company I work for has a File Share server running on an server that is running Windows Server 2022. Its a simple setup that just uses Workgroups rather than a domain controller. They use a CAD software called Microvellum that requires an SQL…
