Backing up and Restoring Acronis Access

In case you need to upgrade, update or maintain your Acronis Access server. This article will give you the basics of backing up your database and restoring it.

Note: If your Acronis Access server database is very large, several gigabytes, you may want to use a different backup and restore method for your database. Please contact our technical support at http://www.acronis.com/en-us/mobilitysupport/ for help and instructions.

Backing up Acronis Access

Backup the Access Server's database

  1. Stop the Acronis Access Tomcat service
  2. Open the Acronis Access PostgreSQL Administrator application and connect to the database server. You may be prompted to enter the password for your postgres user.
  3. Expand Databases and right-click on the acronisaccess_production database.
  4. Choose Maintenance -> Vacuum and press OK.
  5. Expand the database, expand Schemas and expand Public. Take note of the number of the Tables section. This will help you verify that the database transfer is successful.
  6. Close the PostgreSQL Administrator and open an elevated command prompt.
  7. In the command prompt, navigate to the PostgreSQL bin directory.

    e.g. cd "C:\Program Files\Acronis\Access\Common\PostgreSQL\9.3\bin"

  8. Enter the following command: pg_dumpall --host localhost --port 5432 --username postgres --inserts --file alldbs_inserts.sql
  9. Copy the backup file to a safe location.

Backup the Gateway Server's database

  1. Stop the Acronis Access Gateway service.
  2. Go to the Gateway Server database folder, by default located at:

    C:\Program Files (x86)\Acronis\Access\Gateway Server\database

  3. Copy the mobilEcho.sqlite3 file to a safe location.

Additional files to backup

If you've made changes to any of these files, it is recommended to make backups so you can transfer your settings when restoring or migrating your Acronis Access product.

Restoring Acronis Access

Restore the Access Server database

Note: We strongly recommend that you run a test backup/restoration outside of your production environment.

  1. Open the Services control panel and stop the Acronis Access Tomcat service.
  2. Open the Acronis Access PostgreSQL Administrator application, connect to the local database server, select Databases, and confirm there is a database called acronisaccess_production.
  3. Right-click on the database and select Refresh.
  4. Expand it and expand Schemas, expand Public and verify that there are zero (0) Tables.
  5. Close the PostgreSQL Administrator and open an elevated command prompt.
  6. In the command prompt, navigate to the PostgreSQL bin directory.

    e.g. cd "C:\Program Files\Acronis\Access\Common\PostgreSQL\9.3\bin"

  7. Copy the database backup file alldbs_inserts.sql (or whatever you have named it) into the bin directory.
  8. In the command prompt, enter the following command: psql -U postgres -f alldbs_inserts.sql
  9. Enter your postgres password when prompted for it.

    Note: Depending on the size of your database, the restore can take some time.

  10. After the restore is complete, close the command prompt window.
  11. Start the Acronis Access Tomcat service.

Restore the Gateway Server database

  1. Copy the mobliEcho.sqlite3 Gateway Server database backup into the new Gateway Server's database folder (by default C:\Program Files (x86)\Acronis\Access\Gateway Server\database) replacing the existing file.