Follow

Backup and/or Restore Food Processor with Database Utility

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

db-backup.png

or select the Backup Database icon

db-backup-icon.png

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.

  • Avatar
    Connie Ziegler

    I have the same issue...

  • Avatar
    Nate Edwards

    If no database utility is installed, you may need to use SQL Management Studio: https://esha.zendesk.com/hc/en-us/articles/115003525072