Problem replicating SQLServers with Mirroring in place

[daniflexx]

Hello,

I'm trying to replicate two MSSQL Servers that have mirrored databases. Since the Veaam replication does one server and then the other one there is no way to ensure that the replica is consistent between them.

I tried to recover the replicated servers in a lab but the mirroing is always broken in the recovered machines. The only way that it works is stoping the servers before replicating them.

Is there any strategy to clone servers that have to be replicated at the same time?

[Vitaliy S.]

Hello Dani,

Since creating VM snapshots at the same time currently is not technically possible, you should either use per-freeze/post-thaw scripts to start/stop SQL Server services or try to adjust SQL mirroring timeout values (if possible) and schedule these replication jobs to start processing these VMs approximately at the same time.

Thank you.

[dellock6]

Hi, even if it's far from beeing a perfect solution, I did this for a customer of mine to snapshots two VMs who needed to be copied at the same time: just created two jobs, scheduled them to start at the same time, and to be sure no other jobs would fill the proxy queue and delay the start, we deployed a dedicated new proxy, assigned only this two jobs to it, excluded all other jobs (there are different "tricks" to do this), and verified the proxy has cuncurrency set to two so it can start both jobs together.
Hope this helps...

Luca.