Host-based backup of VMware vSphere VMs.
Post Reply
Fab
Novice
Posts: 4
Liked: never
Joined: Jul 18, 2014 2:34 pm
Full Name: Fabien GRAGLIA
Contact:

SQL VM migration ?

Post by Fab »

Hi all,

What happen during Databse VM migration on two differents distant servers ? :

- need stop activity manually on database server (Network, data,...) ?
- auto-freeze database server by Veeam Backup ?
- or, automatic update recent data during transfer ?

thanks !
Fabien GRAGLIA
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL VM migration ?

Post by Vitaliy S. »

Hi Fabien,

In order to migrate SQL Server VM you can either use Quick Migration or replication jobs with permanent failover. During these jobs there is no need to stop activities/services of the application, everything will be orchestrated by Veeam. Where do you plan to migrate your VM? Within the same site?

Thanks!
Fab
Novice
Posts: 4
Liked: never
Joined: Jul 18, 2014 2:34 pm
Full Name: Fabien GRAGLIA
Contact:

Re: SQL VM migration ?

Post by Fab »

Thanks to reply !

I want to migrate my VM on distant site, thanks to a WAN link.

So you confirm that my SQL VM can continue to run during failover, without lose data.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL VM migration ?

Post by Vitaliy S. »

What bandwidth do you have on this link? I wouldn't recommend running production SQL Server on the open snapshot for a long time. I would suggest doing local backup, restoring this file on the remote site and finally creating new replication job mapped to this restored VM. After you do that, run the job and perform permanent failover. Thanks!
Fab
Novice
Posts: 4
Liked: never
Joined: Jul 18, 2014 2:34 pm
Full Name: Fabien GRAGLIA
Contact:

Re: SQL VM migration ?

Post by Fab »

Yes, but this solution implies shutdown "SQL VM", it's right ?
Actualy i don't know bandwidth on WAN link.

So WAN Link it's a real problem for this needing !
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL VM migration ?

Post by veremin »

For a short period of time required to transfer final changes. Thanks.
Fab
Novice
Posts: 4
Liked: never
Joined: Jul 18, 2014 2:34 pm
Full Name: Fabien GRAGLIA
Contact:

Re: SQL VM migration ?

Post by Fab »

Thanks You very much !
Post Reply

Who is online

Users browsing this forum: ronnmartin61 and 75 guests