SQL VM Replication - Failover

Availability for the Always-On Enterprise

SQL VM Replication - Failover

Veeam Logoby afishernwn » Thu 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: 39
Liked: 1 time
Joined: Fri Sep 09, 2016 6:15 pm
Full Name: Adam Fisher

Re: SQL VM Replication - Failover

Veeam Logoby afishernwn » Thu 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?
afishernwn
Service Provider
 
Posts: 39
Liked: 1 time
Joined: Fri Sep 09, 2016 6:15 pm
Full Name: Adam Fisher

Re: SQL VM Replication - Failover

Veeam Logoby v.Eremin » Mon 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.
v.Eremin
Veeam Software
 
Posts: 14704
Liked: 1100 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: tsightler and 62 guests