Discussions specific to the VMware vSphere hypervisor
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 » Jul 18, 2014 2:48 pm

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.
Product Manager
Posts: 22965
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL VM migration ?

Post by Vitaliy S. » Jul 19, 2014 2:29 pm

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 » Jul 20, 2014 6:24 am

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.
Product Manager
Posts: 22965
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL VM migration ?

Post by Vitaliy S. » Jul 20, 2014 7:30 pm

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 » Jul 21, 2014 6:58 am

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: 16867
Liked: 1429 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL VM migration ?

Post by veremin » Jul 21, 2014 7:00 am

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 » Jul 21, 2014 8:52 am

Thanks You very much !

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 18 guests