Note: This article is for using Database Utility (For Instructions on backup using SQL Server Management Studio see this link.
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
or select the Backup Database icon
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.
I am looking to backup the database on our SQL Server. The ESHA software is not installed on that server.
I have the same issue...
If no database utility is installed, you may need to use SQL Management Studio: https://esha.zendesk.com/hc/en-us/articles/115003525072