1. First page
  2. Documentation
  3. Administration Manual
  4. Backup and restore

Backup and restore

Please note: EBA Ltd. is not responsible for backing up databases, this is the responsibility of the tenant. The instructions below are only intended as a recommendation or to assist you in creating a backup and restoring it.

EBA DMS records all data in the database and there are several ways to create a backup:

Using SQL Browser – the recommended way

This tool is installed by installing the EBA DMS client.

Start the tool and set up the connection to the database. Select Backup database from the Tools menu.

Using the tool in the EBA DMS client

The tool is accessed from the Tools>Backup menu. Choose whether you want to create or import a backup.

The program asks for the path to the file and the step is completed by pressing the Apply button

Figure 1: Creating a backup


Backup at SQL level

PostgreSQL

Automated backup of a PostgtreSQL database is created using the built-in pg_dump.exe tool and the Windows Task Scheduler.

  1. Run CMD as administrator.
  2. Navigate to the PostgreSQL installation file, in the bin folder.
  3. Enter the appropriate command to create the backup, the options are as follows:

U postgres: define the user you want to connect to the PostgreSQL server. In our example, this is the postgres user.

W: the program asks you to enter a password for the user. When you run the program with ENTER, you will be asked to enter the password.

F: defines the format of the backup, the options are:

  • c: custom-adapted format
  • d: archive format as directory
  • t:tar record
  • p: plain text record


Example of a command to create a backup:

C:\Program Files\PostgreSQL\9.5\bin>pg_dump.exe -U postgres testeba > C:\eba_share\db\testeba.sql


Automated backup

With the Windows Task Scheduler, you can set the above command to run at a specific time.

We also recommend using the pgAdmin tool and backup as file.

Microsoft SQL

To create a backup, we refer to the following instructions:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15


What else to archive?

INI file

The only EBA DMS file that makes sense to back up, apart from the database, is the init.ini setup file

The latter is located in the folder you specified when installing the program, you can also check the location using regedit. See the instructions for connecting the EBA DMS client to the database.

Installation files

We also recommend that you keep a copy of the installation files of the current version of the system you are using, just in case. Typically these are 3 files, the x86 client, the x64 client and the application services.

Articles

How can we help?