Notifications
Clear all
Topic starter
Last weekend, one of our staff discarded a document.
What steps are required to restore a that document from a database backup?
What tables should be restored? I am assuming we restore the document table at the very least to a temporay table. Would we then insert the missing record from that table into the production table? If it is only information stored in the note text only, would it be better to pull that text out and recreate the document by hand?
I have already contacted GE support..
Thanks,
John
Outside In
Posted : January 15, 2015 7:38 am
I think it would be easier just to grab the document hold text out of a backup of the documents table:
1. Restore backup document table as DOCUMENT_BAK
2. Run this query in SQL Management Studio. Substitue Last name and first name with that of the patient you are recovering:
SELECT Last,First,PatientID,HOLDTEXT,dbo.Convert_ID_to_date(DOCUMENT_BAK.clinicaldate) as ClinicalDate FROM DOCUMENT_BAK
INNER JOIN PatientProfile pp on DOCUMENT_BAK.PID=pp.PId
WHERE pp.last='ADDLASTNAME'AND pp.First='ADDFIRSTNAME'
ORDERBY ClinicalDate DESC
3. Select the HoldText field data from the record you need from results. Copy (Control+C) to clip board
4. Open up notepad. Paste file data in (it will be RTF format.)
5. Now save as .rtf file instead of a .txt file.
6. Open file with WORDPAD. It should appear pretty well formatted.
7. Copy contents from Wordpad into body of a new chart update.
8. Reenter any missing clinical list data into the update
Hope this helps. Good luck!
Posted : January 15, 2015 9:01 am
Topic starter
If there are observations stored along with text, is that also possible or not?
Thanks again.
John
Posted : January 15, 2015 9:23 am
What I would do is create a new Backup Database, restore it all into there, then find the SDID from the backup and its pretty much copying over the record to your live, DOCUMENT, SYMBOLS, OBS tables records will need to be used to get your info back using the SDID to find the records. Hope this helps.
Posted : January 15, 2015 9:34 am
