Host-based backup of Microsoft Hyper-V VMs.
Post Reply
Tank
Lurker
Posts: 1
Liked: never
Joined: Aug 31, 2018 1:25 am
Full Name: Roger Gaudet
Contact:

Using Veeam to migrate SQL VM from one Cluster to another?

Post by Tank »

I am in the process of deprecating an old 2012R2 Cluster and SAN to new 2019 Cluster and SAN. I have used Veeam to backup and restore the VM to new resource with no issues whatsoever. This last VM is my SQL server for my sfB 2015 installation. My backup will fail if I attempt anything other than a copy (so no application aware backup job), but good backup with just the copy. What I am wanting to do is confirm a workflow
1. Shutdown the SQL server VM to a totally off state
2. Backup the shutdown VM with Veeam
3. Restore it to new cluster resource
4. Start VM on new cluster

I honestly can't think of why this would not be 100% optimal and work, but asking just in case I am missing something.
Thanks.
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Using Veeam to migrate SQL VM from one Cluster to another?

Post by HannesK »

Hello,
and welcome to the forums.

as a powered off standalone SQL machine must be consistent, your idea looks good to me.

For a migration, I would always use a powered off backup as source (well, or planned failover which also powers off machines before the final replication step). With powered on machine backups, there would always be data loss since the last backup.

Best regards,
Hannes
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 24 guests