ESET Online Help

Search English
Select the category
Select the topic

Database Server Backup and Restore

All ESET PROTECT information and settings are stored in the database. We recommend that you back up your database regularly to prevent loss of data. You can use the backup later when migrating ESET PROTECT to a new server. Refer to the appropriate section below for your database:


The names of databases and log files are staying same even after the change of the product name from ESET Security Management Center to ESET PROTECT.

If you use ESET PROTECT Virtual Appliance, follow the VA database backup instructions.

MS SQL Backup examples

To backup an MS SQL database to a file, follow the examples shown below:


These examples are intended for use with default settings (for example, default database name and database connection settings). Your backup script will need to be customized to accommodate any changes you have made to default settings.

You need to have sufficient rights to run the commands below. If you do not use a local administrator user account, you need to change the backup path, for example to 'C:\USERS\PUBLIC\BACKUPFILE'.

One time database backup

Execute this command in a Windows command prompt to create a backup into file named BACKUPFILE:



In this example, HOST stands for the IP address or hostname and ERASQL for the name of the MS SQL server instance. You can install ESET PROTECT Server on a custom named SQL instance (when using MS SQL database). Modify backup scripts accordingly in this scenario.

Regular database backup with SQL script

Choose one of the following SQL scripts:

a)Create regular backups and store them based on date of creation:




3.REN BACKUPFILE BACKUPFILE-[%DATE:~10,4%%DATE:~4,2%%DATE:~7,2%_T%TIME:~0,2%%TIME:~3,2%].bac

b)Append your backup to one file:




MS SQL restore

To restore a MS SQL database from a file, follow the example shown below:


MySQL backup

To backup a MySQL database to a file, follow the example shown below:

mysqldump --host HOST --disable-keys --extended-insert --routines -u ROOTLOGIN -p DBNAME -r BACKUPFILE


In this example, HOST stands for the IP address or hostname of the MySQL server, ROOTLOGIN for the root account of the MySQL Server, and DBNAME stands for ESET PROTECT database name.

MySQL restore

To restore a MySQL database from a file, follow the example shown below:



For more information on Microsoft SQL Server backup, please visit Microsoft technet website. For more information on MySQL Server backup, please visit MySQL documentation website.