Option 1: Restore a Backup to a Test System to Retrieve the Deleted Data In this procedure you will restore a backup to a test system in order to retrieve the deleted data, and then re-enter that data into your production system. This is usually the best recovery option unless you have to recover a large amount of data.
- Identify the most recent backup of your database that includes the records that were deleted.
- Restore the backup to a test environment. Do not restore the database to your production system. Caution: Setting up a test environment can be time-consuming process, especially with client/server systems, and should only be performed by staff who fully understand the process to ensure that your production database is not affected by the test system. If you accidentally restore a backup to your production system, you will lose all data that was entered after that backup was made. MicroEdge highly recommends that you consult your organization's IT department before restoring a database backup to a test environment.
- Print out the data you wish to re-enter into your production system.
- Enter the retrieved data into your production system.
Option 2: Restore a Database Backup and Re-Enter Newer Data If the amount of data you need to retrieve exceeds the amount that has been entered since your last database backup, this option is usually the most efficient means to restore your data. Keep in mind that all data entered by all GIFTS users since your last backup will need to be re-entered:
- Ensure that all users are logged out of GIFTS for the duration of this process. Any data that is entered after you begin this process will be lost.
- Print reports that include all of the data that has been entered since your last backup. Caution: Be sure to retrieve all data that has been entered since your last backup was performed. If you are not sure that you can identify every record that has been created since your last backup, MicroEdge does not recommend that you proceed.
- Restore your most recent backup. Caution: Ensure that you are restoring your organization's most recent backup. MicroEdge highly recommends that you consult your organization's IT department before restoring a database.
- Using the reports that you created in Step 2, re-enter all of the data that was entered after the creation of the backup that you have restored.