You are here: Ajera Help (A-Z) > databases > Restore a database backup

Restore a database backup

Ajera Cloud clients: You do not complete this task. Contact Ajera Support for backup assistance.

Before you begin

Verify that you are set up in Ajera with an Administrator role in your original Ajera database. Only employees with that role can restore an Ajera database.

To restore a database backup

Caution:

When restoring database backups, Ajera OVERWRITES all changes entered since your last backup. Ajera Support cannot restore overwritten data.

To avoid losing changes, back up your current data.

Verify that all employees have exited Ajera.
On your Ajera server, open your Ajera folder and double-click the AjeraServerAdministration.exe file to open the Ajera Server Administration tool.
From the Tasks menu, click Restore Database.

Note:

If using the upload attachment (FileStream) feature, Ajera automatically backs up your FileStream data. When restoring data, if the .bak file being restored does not contain the matching FileStream data, you will be warned. It is important that you backup and restore the FileStream data at the same time as the Ajera data.

On your Ajera server, navigate to and select the backup file that you want to restore. Click Restore.

Click Yes to confirm that you want to restore the database. Ajera notifies you when it has successfully restored and updated your database.

If a FileStream database was backed up, this also restores the backed up FileStream database.

To restore multiple databases, repeat the above steps for each database separately.

Tasks

Back up a database

Delete a database backup

Step 1: Create multiple databases

Step 2: Set up database administrators

Step 3: Rename databases

Move Ajera databases to a new server