Safe to live migrate a running VM that runs MS-SQL?

Darkk

Well-Known Member
Sep 2, 2019
102
20
58
55
I currently use ZFS with replication between the nodes on the same cluster. Normally I never experienced any issues of moving an active VM between the nodes but have to wonder is it safe to do that when a VM is running MS-SQL? Or shouldn't matter long as it's not very busy VM and captures the RAM during migration?

I usually just shutdown the MS-SQL VM before moving it to another node to be safe.

I have other VMs running MySQL and PostgreSQL without issues with live migrations. Just curious about Microsoft SQL 2017.

Thanks.
 
Last edited:

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!