mssql

  1. K

    proxmox deployment

    Hello everyone Quick backstory. We have 2 main programs, both of them are using SQL server on windows. We used Hyper-V, but it wasn't very fast, nor secure enogh (periodic backups). Both of these systems are crucial for our company, so the best way would be to have some sort of continuity of...
  2. N

    Benchmarking ZFS for Database Performance (MSSQL)

    This thread should provide some information on how you might be able to optimize I/O performance for your VMs. Please: If you post answers with test-outputs - use the 'inline spoiler' ;) For those that are interested in the charts and values see: docs.google.com/spreadsheets Warning: We are no...
  3. B

    Proxmox HA + MSSQL Failover Cluster

    Hi all, I am in the process of configuring a Proxmox High Availability (HA) cluster and I plan to run Microsoft SQL Server with a failover cluster setup, but without using an external NAS for storage. This setup is somewhat complex and I find myself in need of guidance from someone with...
  4. ugf

    MSSQL Instanzen frieren ein

    Hallo, wir haben mehrere MSSQL-Instanzen, die sporadisch und nicht reproduzierbar immer mal wieder einfrieren. Per VNC kann dann noch die Maus bewegt werden. - Die Serverzeit bleibt stehen - Kein Login (STRG+ALT+ENT) möglich - Keine Logs in der VM werden geschrieben - Egal ob lokaler ZFS oder...
  5. D

    Windows Server Failover Cluster

    I have a need to configure a cluster for use with MSSQL however the validation is failing which I suspect is because it can't see the disk in the way it wants. Has any one encountered this before? Or know what the issue could be?
  6. V

    MSSQL Backup Error when proxmox create snapshot

    Hi, when i create backup image in proxmox, using mode "Snapshot", MSSQL writes to windows log: and and vss As a result, Proxmox backup is ok. And when i disable Qemu guest vss provider - i've not see this errors. Why this happens? I have another VM with MSSQL on the same node, and using...
  7. A

    MSSQL server backup chain becomes broken after snapshot backup

    Proxmox VE 5.3 Windows Server 2016 VM (Qemu Agent enabled) SQL Server 2016 Backup conf: Inside Windows Server 2016 VM I have an app which runs MSSQL backups - a full backup once per week and differential backup once per day. After Proxmox makes a snapshot, MSSQL backup chain becomes broken so...