How do I recover a file which has been deleted from a document?

Question

A file was accidentally removed from a Docuemnt Record. 
 How can I find out there the file was stored on the eB server and recover it for th euser? 
 
 Thanks 
 
 Russell

Roberto Garcia · Accepted Answer

HI Russell, 
 There is no quick way to recover the file. The only way will involve having a backup of the database and the storage device, and following these steps: 
 1. Restore a backup of the database onto a test server 
 2. Work out where the file exists in the repository using an SQL command. We will need at this point the identifier for the document (prefix - middle - revision) 
 3. Get the file from a backup 
 4. Rename the file back to original format 
 5. add the recovered files via front end. 
 If you have available the DB and storage backups and want to try the steps above, let me know and I will send you details via email. 
 thanks

Roberto Garcia · Answer

Hi Tony, 
 
I am sending the requested information via email now. 
 
thanks,