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.
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Aug 31, 2018 1:25 am
- Full Name: Roger Gaudet
- Contact:
-
- Product Manager
- Posts: 14837
- Liked: 3084 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?
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
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
Who is online
Users browsing this forum: No registered users and 23 guests