Unfortunately, deletion of records in your database is final and cannot be undone.
*Note : To delete a record in GIFTS, users must open the record, select Delete and then click Yes to confirm that they want to delete the record. Therefore, it is highly unlikely that data be accidentally deleted due to a "typo" while working. Be sure that your users understand that deleted records cannot be easily retrieved.
It is possible to restore the most recent backup of your database to retrieve records that have been deleted since that backup was run. However, any changes that have been made to your data since that time will be lost and will have to be re-entered.
*Tip: If the deleted data is still available from a source other than Grantmaking or GIFTS, the best and safest course of action is to re-enter the deleted data.
Based on the volume of data that has been entered since your last database backup, you can use either of the options described in this article to retrieve data from an earlier copy of your database. If neither option is practical, contact Blackbaud Customer Support to discuss additional options that may be available.
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. Blackbaud 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 Grantmaking/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, Blackbaud does not recommend that you proceed.
- Restore your most recent backup. Caution: Ensure that you are restoring your organization's most recent backup. Blackbaud 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.