Automatic Backup of Deleted Records

Some people are concerned with records being deleted by mistake. This is very difficult to do and Prime also has a built in feature that backs up the records before they are deleted. Like the recycle bin in Windows, Prime first backs up any record that is deleted by any method and puts a copy in a table that has the original name plus _deleted at the end. These tables are not usually visible from the front end, but show up when going into the SQL Management Studio. Note: This only backs up a record if it is completely deleted and not if it is just changed.

If a record was deleted by mistake, it can usually be copied and pasted back into the original table by going into the appropriate table, e.g. ClientsW_deleted, copying the row and pasting it back into ClientsW.

The Applications Administrator should review these tables every few months to insure that data is not being incorrectly deleted. This is done by going into the SQL Management Studio and looking at the records in each _deleted table. These records can be purged if they were correctly removed.

These are the tables where the backups are stored:

1) Agency_deleted

2) Calendar_deleted

3) Callback_deleted

4) ClientsW_deleted

5) ClientsWCaseNotes_deleted

6) Compens_deleted

7) Conflict_deleted

8) Eligibility_deleted

9) LawFirm_deleted

10) Lawyers_deleted

11) OService_deleted

12) Trust_deleted

13) Ttime_deleted

14) TtimePBI_deleted