Zerto Virtual Replication and VMware Features : Backing Up an External Zerto Virtual Replication Database - a Single Database on the SQL Server
  
Backing Up an External Zerto Virtual Replication Database - a Single Database on the SQL Server
Follow this procedure when:
■ The SQL database, which contains the Zerto Virtual Replication database, runs on a separate virtual machine to the Zerto Virtual Replication machine.
■ The Zerto Virtual Replication database is the only database on the SQL Server.
To Back Up an External ZVR Database - a Single Database on the SQL Server
1. On Site Y, create a VPG of the protected Zerto Virtual Replication VM and SQL VM.
■ Only the Zerto Virtual Replication VM and the SQL VM must be in this VPG.
■ Configure the Zerto Virtual Replication VM with the same IP address with which it is currently configured.
■ Configure the SQL VM with the same IP address with which it is currently configured.
2. (Optional) On Site Y, create a manual checkpoint on the VPG.
3. On Site Y, power down the protected Zerto Virtual Replication VM and SQL VM.
4. On Site Y, rename or delete the Zerto Virtual Replication VM.
In the event of a disaster, this is the VM which is protected, and which will be recovered.
And therefore you need to rename or delete the VM, so that if there is a disaster and you need to recover, there will be no duplications or naming conflicts.
5. On Site Y perform a Failover LIVE committed on the VPG which is protecting the powered down Zerto Virtual Replication VM and SQL VM.
6. On Site X, the recovery site, power off the failed over Zerto Virtual Replication VM and the SQL VM. Do this so that later on in the procedure you are able to copy it back to Site Y.
Then export:
■ The failed over Zerto Virtual Replication VM to an OVF/OVA.
■ The failed over SQL VM to an OVF/OVA.
7. On Site Y, import both the OVF/OVA’s which were exported in step 6.
8. On Site X, delete the powered off Zerto Virtual Replication VM and the SQL VM.
These are the VMs which were failed over in 5. The powered off VMs cannot be used, and deleting them triggers the deletion of the VPG.
9. On Site Y, power on the Zerto Virtual Replication VM, and the SQL VM, which were imported in 8.