Database Requirements in Hyper-V Environments
By default, an embedded SQL-based database is used but it is possible to use an externally managed database, Microsoft SQL Server. To use an externally managed database, during the installation choose the Custom Installation option.
The following Microsoft SQL Server versions are supported: 2008, 2008R2, 2012, 2014, 2016.
You must have the following permissions set:
■ Public and dbcreator server roles.
■ Permission to connect to the database engine.
■ Login enabled.
■ In User Mapping choose the master database under which to create the Zerto Virtual Replication database and set both db_owner and public for database role membership.
Zerto recommends using SQL Server Enterprise Edition if you have 4 or more sites, or 40 or more hosts with virtual machines being protected or recovered, or more than 400 virtual machines to be protected.
Using an externally managed database requires the following configuration for the machine running SQL Server:
■ 4 CPUs or 2 Dual Core CPUs and 16GB RAM.
■ 20GB to accommodate the database and the logs generated by the Zerto Virtual Manager.
Note: If SQL Server is used, it is your responsibility to make sure that database downtime is planned in coordination with your disaster recovery and business continuity requirements. During database downtime, there will be inconsistencies between Zerto Virtual Managers, such as the management of checkpoints, resulting in problems if a recovery is required.