I am looking for ideas to restore a large backup on a VM hosting SQL Server that is replicating to another VM in a remote location (Hyper-V VM Replicaton). Restoring it will replicate the restored backup consuming a lot of the bandwidth between both sites.

Both sites are in same city. Would it work if I pause the VM replication, restore the DB on both local and remote VMs, then resume replication? This will save from wasting bandwidth.

I know I can break the replication, restore the DB, export the local VM and import into the remote site. It would work, but there are other DBs on the VM server. The exported VM image would be huge. The other issue with this. I will need to repeat this process when moving other databases into the local VM which does not sound like a good idea.

Is there a better way?


  • 2
    This sounds like it's more of a Hyper V replication question than a database question. The fact that it's SQL Server inside the VM is really coincidental. Any "tricks" to avoid the replication overhead would likely need to be done at the HyperV layer, not the SQL Server layer
    – AMtwo
    Oct 25, 2019 at 12:15

1 Answer 1


If you start the VM on the passive site, that will cause the VM to be out of sync with the active system and it will have to resync. So whatever you do while the passive system is online, it will be wiped out when the VMs are synced up again. The simple act of booting the passive system causes writes to the event logs, registry, and numerous other things that result in it being out of sync with the active system, so the question of what you do thereafter, whether it be restoring a database, modifying files, etc., is irrelevant as the VM will have to be resynchronized with the primary.

The only way your proposed operation might possibly help is if you can get the database files restored at the exact same addresses on the disk, and then the block comparison of the sync process would see those parts of the disk as identical. However, this is not something that is reasonable to attempt.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .