Recently we moved clustered SQL Server 2017 running on Windows Server 2016 from physical to VMWare, since then everyday it started failing over at same time. No Error in SQL Server logs but Windows Event log shows SQL Server not being able to access data and log files before failover. On investigation we found that virtual machine backup was scheduled that time. Disabling the VM backup stopped the failover.

  • 1
    Lot of information is missing. What version of VMWare? What type of backup? What is the placement of the data files/transaction log/tempdb? What type of storage is used? – Greg Askew Jul 8 '20 at 11:59
  • 1
    There are some VERY specific requirements for doing MS clustering in ESXi VMs - did you follow them? kb.vmware.com/s/article/2147661 – Chopper3 Jul 8 '20 at 12:15
  • VMware ESXI version is 6.7. Incremental snapshot backups done by Tivoli Storage Manager. data and log files on NAS ISCSI with MPIO while tempdb stored on separate disk. – alex Jul 8 '20 at 12:19
  • What is the performance of the NAS? Is it using spinning disks? Same for tempdb. – Greg Askew Jul 8 '20 at 12:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.