Recovering deleted records from Content Manager
I was just wondering whether anyone knew of a method to recover deleted records from Content Manager ?
The doc store has previous revsions switched on - However the issue is getting the Doc Store ID of the record that was deleted. The audit log brings back certain record details of the one that was deleted but nothing relates to the Doc Store ID ?
We usually go straight to workgroup server logs (C:\HPE Content Manager\ServerLocalData\TRIM\Log), there's quite a lot of data in them but if you know the time/date when things occured it is much easier to pare them down.
If this deletion is recent you may choose to restore the Database to some dev or non prod machine. Using this restored database ypu cam run a query on the Record Electronic (TSRECELEC something like that). It will tell you the exact file location that you can look into your DocStore ID to extract the file from prod. There are few other (advanced level ) options to repopoulate the record etc however with db restore you will get the attached doc out.
Content Manager has no built-in 'recovery' for deleted documents.
As Harry mentioned, your best approach will be to restore a copy of an older database to an NPE environment or temporary location.
This would give you the option to either query directly as a temporary dataset to get the document store metadata, or have a SQL Admin query on your behalf (from memory I think the Document Revision table is TSRECEVSN).