Availability for the Always-On Enterprise
Post Reply
afishernwn
Service Provider
Posts: 41
Liked: 1 time
Joined: Sep 09, 2016 6:15 pm
Full Name: Adam Fisher
Contact:

SQL VM Replication - Failover

Post by afishernwn » Jun 14, 2018 12:15 pm

I have a customer who is looking to test failover for a SQL VM that is currently protected via replication from Prod to DR. They would like to test failover of that SQL VM (vSphere hypervisor) and I am curious if there are other steps specific to SQL that go beyond a typical VM failover. It seems with the transaction logs and other intricacies of SQL there would be some manual steps for this to work, but haven't had experience with this scenario yet. Has anyone tested this and is it really as easy as any other VM failover? Or are there SQL specific things that need to happen for this to work properly?

afishernwn
Service Provider
Posts: 41
Liked: 1 time
Joined: Sep 09, 2016 6:15 pm
Full Name: Adam Fisher
Contact:

Re: SQL VM Replication - Failover

Post by afishernwn » Jun 14, 2018 12:45 pm

Some further searching in the forums makes it look like the planned failover option would be the way to go. This essentially would be similar to powering off the VM, moving to the other location and powering back on. As long as application-aware processing is enabled on the job, that should be all there is to it. Sound about right?

v.Eremin
Veeam Software
Posts: 15140
Liked: 1141 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL VM Replication - Failover

Post by v.Eremin » Jun 18, 2018 1:47 pm

Correct, the planned failover will make sure that replica VM is identical to production one and then switch workload to it. Thanks.

Post Reply

Who is online

Users browsing this forum: No registered users and 37 guests