Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Document restore from backup

General Discussion

Last Post by acantu 10 years ago

4 Posts

3 Users

0 Reactions

70 Views

RSS

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

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

aballard

(@aballard)

Posts: 43

Trusted Member

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

jmkoi

(@jmkoi)

Posts: 54

Estimable Member

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

acantu

(@acantu)

Posts: 722

Prominent Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0