Zerto Virtual Replication and VMware Features : Backing Up an External Zerto Virtual Replication Database - Multiple Databases on the SQL Server
  
Backing Up an External Zerto Virtual Replication Database - Multiple Databases 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 one of many databases on the SQL Server.
To Back Up an External ZVR Database - Multiple Databases on the SQL Server:
1. On Site Y, create a VPG of the protected Zerto Virtual Replication VM.
■ There must be no other VMs in this VPG.
■ Configure the Zerto Virtual Replication VM with the same IP address with which it is currently configured.
2. On Site Y, create a VPG of the protected SQL VM.
■ Configure the SQL VM with the same IP address with which it is currently configured.
3. (Optional) On Site Y, create manual checkpoints on each VPG. Do this so that at a later point it is easier to find.
4. On Site Y, power down the protected Zerto Virtual Replication VM.
5. 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.
6. On Site Y, perform a Failover LIVE committed on the VPG which is protecting the powered down Zerto Virtual Replication VM.
7. Make a note on which checkpoint the Failover LIVE is performed. You can use the checkpoint which you created in 3, or you can use a different checkpoint.
8. On Site X, the recovery site, using the File and Folder Restore wizard, restore the database files from the VPG which was protecting the SQL VM.
From this point in the procedure you will copy the failed over Zerto Virtual Replication and SQL VMs back to their original protected Site Y.
To do this:
a) In Zerto Virtual Manager, in the main page at the bottom, click Actions, then select Restore File, and select the SQL VM.
b) Select the same checkpoint which was noted in 7, to which to you will Failover LIVE the Zerto Virtual Replication.
c) Proceed with the wizard. In the relevant window, click Start Mount, then click Browse, and navigate to and select the .MDF and .LDF files from the SQL VM database folder were the Zerto Virtual Replication database is located.
When the disk is mounted, icons appear next to the completed task.
d) Click the folder icon to browse the folders and files on the disk, and to start the download. The default name of the Zerto Virtual Replication database is zvm_db.
9. On Site X, power off the failed over Zerto Virtual Replication VM. Do this so that later on in the procedure you are able to copy it back to Site Y.
10. On Site X, export the failed over Zerto Virtual Replication VM to an OVF/OVA.
11. On Site Y, import the OVF/OVA, which was exported in step 10.
12. On Site Y, verify that the Restore File operation is complete, and that both database files, .MDF and .LDF, were downloaded.
13. On Site Y, power down the SQL VM, and overwrite both Zerto Virtual Replication database files with the .MDF and .LDF files which you downloaded using the Restore File operation.
14. On Site Y, power on the SQL VM which was imported in 11.
15. On Site X, delete the powered off Zerto Virtual Replication VM which was failed over in 6.
The powered off VM cannot be used, and deleting it triggers the deletion of the VPG.
16. On Site Y, power on the Zerto Virtual Replication VM, which was imported in 11.