Article number
000004584
Affected Versions
All
Source Hypervisor
All
Target Hypervisor
All

How to Tell if An External or An Internal DB is in Use

Viewed 641 times

Summary

An admin will want to upgrade their Zerto environment. In the Zerto documentation it states to stop the Zerto service and take a snapshot of the ZVM VM. However, if you have an external DB, you will want to backup the DB as well. Below are the steps to identify if you have an external DB or the internal embedded DB.

Steps

To determine if external or embedded SQL DB is in use by the ZVM:

  1. Open the file "\Program Files\Zerto\Zerto Virtual Replication\storage_properties.xml"
  2. If the value right under m_server is similar to \\.\pipe\LOCALDB#SHD79E11\tsql\query then the SQL database is embedded an located in hidden directory \ProgramData\Zerto\Data. (ZVM snapshot will backup the DB: How to backup database)
OR
  1. If the value right under m.server is an FQDN or IP Address of an SQL Server then the SQL database is externally hosted. (ZVM snapshot will NOT backup the DB. Please have your DBA make a manual backup of the DB (usually named zvm_db) on the external SQL server after stopping the ZVM service: How to backup database)