Krackout's questions

I'm installing a Debian 11 Linux guest on a Hyper-V cluster. Hosts' realtime clocks are set to local time, as is the norm for Windows Servers; unlike the preference of Unix-like OSes. Should I execute timedatectl set-local-rtc 1 on the Linux guest, to be in line with its hosts?

Setting real time clock to local time on Linux systemd servers reports this:

Warning: The system is configured to read the RTC time in the local time zone.
     This mode can not be fully supported. It will create various problems
     with time zone changes and daylight saving time adjustments. The RTC
     time is never updated, it relies on external facilities to maintain it.

If time is synced with an NTP source or from the hypervisor, will there be any potential problems? That's the first part of my question.

Second part,

• Can systemd timesyncd or ntpd sync time with a Windows AD time server (the DC holding the PDC emulator role)? My initial attempt failed for both services. Of course sync time with host was unchecked on VM's settings.
• As an alternative, is syncing time from HyperV host (which in turn is in sync with AD DC) trustworthy?

New MS SQL server 2019 installation on Windows Server 2019, failover cluster role enabled; fully patched Windows, SQL 2019 CU 11.

Nodes:
server1 - 10.10.10.1
server2 - 10.10.10.2

Instances:
sql1
sql2

The instances were initially installed: sql1 on server1, sql2 on server2, clustered install. sql1 and sql2 do failover smoothly, everything works as expected.

The problem is a seemingly harmful event on Windows Logs -> Application (Event ID 18456):

Login failed for user 'domain\server1$'. Reason: Could not find a login matching the name provided. [CLIENT: 10.10.10.1]

and

Login failed for user domain\server2$. Reason: Could not find a login matching the name provided. [CLIENT: 10.10.10.2]

The events are produced when sql1 is moved to server2 and sql2 is moved to server1. It seems that there is some kind of record on each instance with the server that was installed initially and is searching for it. No issues apart from the annoying message.

I've searched the Net a lot, tried the suggestions about disabling CEIP telemetry, disabled sql services one by one to locate the one producing the event (sql server produces it), added the NT AUTHORITY\NETWORK SERVICE to logins, sysadmin on both sql1 & sql2. No effect. Any ideas?

It seems that domain\server1$ is a service account - virtual account. In the initial sql instances installation some services where started by non-domain accounts (default suggestion). But now all services start using domain accounts, yet the event is still produced.

I've got a Debian 10 KVM hypervisor, no libvirt or other tool to administrate it, using QEMU scripts. I need a 32bit Windows VM for a legacy app, but on a supported OS (not XP), either Windows 8.1 or 10 32bit. Both Windows 8.1 & 10 present a message «2GB usable» on system properties when 3GB RAM is assigned (the max capable of handling for a 32 bit machine without other techniques I suppose). On the contrary Win XP seems to use 3GB RAM, stating PAE enabled.

Any ideas how to use 3GB RAM on Win 8.1 or 10, 32 bit?

Here's the screenshot of Win 8.1 VM with 3GB RAM (some on Win 10):

Here is the QEMU script to start the VM (I've also tried host CPU, no difference):

#!/bin/sh
SPICE_PORT=3010
MONITOR_PORT=2330
QEMU_AUDIO_DRV=alsa

kvm \
    -M q35 \
    -nodefaults \
    -cpu qemu64 \
`#  -cpu host` \
    -m 3G \
    -mem-path /dev/hugepages \
    -device virtio-balloon-pci \
    -rtc base=localtime \
    -vga qxl \
    -drive file=win8.qcow2,if=virtio,cache-size=16M,cache=writethrough \
    -device virtio-net-pci,netdev=diktyo0 \
    -netdev user,id=diktyo0 \
    -monitor telnet:localhost:${MONITOR_PORT},server,nowait \
    -device virtio-serial \
    -device virtserialport,chardev=vdagent,name=com.redhat.spice.0 \
    -chardev spicevmc,id=vdagent,debug=0,name=vdagent \
    -spice port=${SPICE_PORT},addr=127.0.0.1,disable-ticketing \
    -device virtserialport,chardev=charchannel1,id=channel1,name=org.spice-space.webdav.0 \
    -chardev spiceport,name=org.spice-space.webdav.0,id=charchannel1 \
    -soundhw ac97 \
    -name "Windows 8.1 x86" \
    -daemonize \

Following shodanshok's advice, I post resource monitor's output (with 4GB total RAM):

Half the memory is reserved by hardware.

I've also increased RAM to 4GB:

Just in case of QXL video driver reserving too much memory, I also changed the line configuring video to:

-device qxl-vga,vgamem_mb=64,ram_size_mb=64,vram_size_mb=64

I may try to change the Seabios, at least the version. Unfortunately in Debian Stable QEMU version is 3.1.0; it's quite old, I wonder if the same behaviour appears in newer versions.

I have to migrate VMs to new storage for a client. Hypervisor is Oracle VM, versions 3.3 & 3.4. Haven't access to the machines yet, I'm searching for info for live storage migration on this platform, Oracle VM.

In Oracle docs, Oracle VM 3.4 docs this doesn't seem possible (only if the VM is stopped). In Oracle VM datasheet it mentions, Storage live VM migration, perform live migrations of running virtual machines that have virtual disks on local storage.

So I am confused. Does anybody have any experience of live storage migration on Oracle VM, versions 3.3 & 3.4?

I need to restore an MS SQL 2008 R2 server. The original server was completely destroyed, nothing to salvage. Yet there is backup of all data, plus system databases, master, msdb, model; .bak files.

I setup a new machine, exactly same version of sql, 2008R2 SP2, and tried to restore master db first. The restore succeeded, but then the sql service could not start, using the recovered master. It seems that every path on the old-destroyed server was custom, data DBs, system DBs, even sql executables.

Is there any way to figure out the paths used on the old server, even for sql executables?
I suppose I'll have to uninstall-install sql server again, to have all custom paths set, in case we locate the custom executable paths, is this correct?
Also, for future reference, on an MS SQL server, is there any way to export all these paths?