Follow

How to Backup and/or Restore the Database

Backing Up:

1. Exit the ESHA software from all computers.

2. On the computer which houses your database...click Start/Programs/ESHA/[ESHA application name]/Database Utility.  Note: in later operating systems, you can just start typing 'Database Utility' and Windows should present the application to open.

3. On the menu, click Database/Backup.

4. Select a location and name for the backup. NOTE: The backup must initially take place to the local computer.  After complete, you may move the .bak file created by the backup anywhere necessary to archive it.

Restoring:

1. Exit the ESHA software from all computers.

2. On the computer which houses your database...click Start/Programs/ESHA/[ESHA application name]/Database Utility.  Note: in later operating systems, you can just start typing 'Database Utility' and Windows should present the application to open.

3. On the menu, click Database/Restore.

4. Locate & highlight the .bak file from which you wish to restore.

5. Click OK.

6. After the Restore completes, there is likely need to (re)add your login as a valid user.

7. Still in Database Utility, click Users / Manage.

8. Click New.

9. If needed, change the login name to the proper username of the user who will need to run the software.  Often this is the name that appears by default.

10. Click Create.

11. Close Database Utility and test the application to see if your data is present.

Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Dave Weinreich

    I am looking to backup the database on our SQL Server. The ESHA software is not installed on that server.

Powered by Zendesk