Recovering Deleted Records

navi95

Registered User.
Local time
Today, 09:39
Joined
Jan 3, 2013
Messages
59
Hi all,

Is there any way of recovering deleted records from a table? And what if the database has been compacted and repaired?

My client wants to have a lot of privacy with his database so I just wanted to verify this.

Thanks! :)
 
once a record is deleted, it's gone and cannot be recovered. Standard practice is to never delete a record except those that are 'wrong' in some way. Instead have a 'Deleted' flag field the users can set to true and modify your queries to only include records records where 'deleted' is false. You can then have a separate admin process to review those records where deleted is true and the admin user can then delete the records properly if required.
 
Right ok excellent, thanks for the quick reply!
 
I hate deleting stuff. It generally costs a lot to get records into a database, and I am reluctant to throw the investment away. Hence I echo CJ's comments.

The fact that records are there but are deleted may be useful for statistical analysis anyway. Unsuccessful quotes vs successful quotes, etc.
 
Unsuccessful quotes vs successful quotes
common one for me is where clients buy in lists of names. If they delete the record where contact has requested 'no contact', they (can) reappear when a new list is added
 
For the biggest database I ever managed, deletion was necessary. However, our solution was to export the database to formatted text files. We marked the record for archiving. We archived it via the text-based export. THEN we deleted it.

For us, retention of old records was mandatory but ONLINE retention wasn't. By having it as a human-readable text file, we met the record-keeping requirements but made room for the new stuff anyway.
 

Users who are viewing this thread

Back
Top Bottom