Database Server Backup/Upgrade and ESET PROTECT Database Migration

ESET PROTECT uses a database to store client data. The following sections detail the backup, upgrade and migration of the ESET PROTECT Server (ESMC Server, ERA Server or ERA 6.x Proxy) database or MDM database:

If you do not have a database configured for use with ESET PROTECT Server, Microsoft SQL Server Express is included with the installer. The ESET PROTECT 8.0 All-in-one installer installs Microsoft SQL Server Express 2019 by default. If you are using an older Windows edition (Server 2012 or SBS 2011), Microsoft SQL Server Express 2014 will be installed by default.

If you have an older unsupported database installed (MySQL 5.5 or MSSQL 2008), upgrade your database to a compatible database version before upgrading the ESET PROTECT Server.

note

Note

The ERA Proxy component from the version 6 is substituted by third-party proxy service due to change of Agent replication protocol. Do not migrate the Proxy database version 6.

Are you upgrading an environment with ERA Proxy?

The following requirements for Microsoft SQL Server must be met:

Install a supported version of Microsoft SQL Server. Choose Mixed mode authentication during installation.

If you have Microsoft SQL Server already installed, set authentication to Mixed mode (SQL Server authentication and Windows authentication). To do so, follow the instructions in this Knowledgebase article. If you want to use Windows Authentification to log in to Microsoft SQL Server, follow the steps in this Knowledgebase article.

Allow TCP/IP connections to the SQL Server. To do so, follow the steps in this Knowledgebase article from part II. Allow TCP/IP connections to the SQL database.

note

Note

To configure, manage and administer Microsoft SQL Server (databases and users), download SQL Server Management Studio (SSMS).

We recommend that you do not install SQL Server on a Domain Controller (for example, if you are using Windows SBS / Essentials). We recommend that you install ESET PROTECT on a different server or do not select the SQL Server Express component during installation (this requires you to use your existing SQL or MySQL Server to run the ESET PROTECT database).

 

ESET PROTECT Database migration

These instructions apply to ESET PROTECT database migration between different SQL Server instances (this also applies when migrating to a different SQL Server version or when migrating to a SQL Server hosted on a different machine):

Migration process for MS SQL Server

Migration process for MySQL Server