Database SQL Server Corrupt Proxmox

[antoniormjr]

Hello everyone, I have a problem and I would like some help. Currently I have 4 servers a cluster and an FC storage, I'm using LVM. I have a vm Windows Server 2008 R2 with SQL Server 2008 and a Windows Server 2012 with SQL Server 2012. There were two electrical problems in which I shut down my servers and UPS, I turned on the servers and everything went back to normal but my SQL Server banks did not return . I backed up Windows and restored the same backup and SQL databases normalized. Could someone please tell me why this occurs with SQL Server in proxmox?

Note: The electrical problem has already been corrected.

Proxmox-ve: 4.4-77 (running kernel: 4.4.35-1-pve)
Pve-manager: 4.4-5 (running version: 4.4-5 / c43015a5)
Pve-kernel-4.4.6-1-pve: 4.4.6-48
Pve-kernel-4.4.35-1-pve: 4.4.35-77
Pve-kernel-4.4.15-1-pve: 4.4.15-60
Pve-kernel-4.4.19-1-pve: 4.4.19-66
Lvm2: 2.02.116-pve3
Corosync-pve: 2.4.0-1
Libqb0: 1.0-1
Pve-cluster: 4.0-48
Qemu-server: 4.0-102
Pve-firmware: 1.1-10
Libpve-common-perl: 4.0-85
Libpve-access-control: 4.0-19
Libpve-storage-perl: 4.0-71
Pve-libspice-server1: 0.12.8-1
Vncterm: 1.2-1
Pve-docs: 4.4-1
Pve-qemu-kvm: 2.7.0-10
Pve-container: 1.0-90
Pve-firewall: 2.0-33
Pve-ha-manager: 1.0-38
Ksm-control-daemon: 1.2-1
Glusterfs-client: 3.5.2-2 + deb8u2
Lxc-pve: 2.0.6-5
Lxcfs: 2.0.5-pve2
Creu: 1.6.0-1
Novnc-pve: 0.5-8
Smartmontools: 6.5 + svn4324-1 ~ pve80
Zfsutils: 0.6.5.8-pve13-bpo80

 

[udo]

Hi,
hard to say… don't know what happens during your power outage - perhaps not writte cache of the FC-Raid?

One important thing: you should upgrade your kernel - afaik 4.4.35-1 has an known issue with oom-killer (and don't forget to reboot after dist-upgrade).

Udo