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

Disaster Recovery

Page 1 / 2 Next

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

16 Posts

6 Users

0 Reactions

154 Views

RSS

C J Torontow

(@cjtorontow)

Posts: 45

Trusted Member

Topic starter

Has anyone lost a SQL database then merged that data back into the production after recovery of the original?

Help! Frown

Posted : October 25, 2012 2:31 am

acantu

(@acantu)

Posts: 722

Prominent Member

Yes, what is the issue you are having?

Posted : December 3, 2012 1:34 am

C J Torontow

(@cjtorontow)

Posts: 45

Trusted Member

Topic starter

Thanks for getting back, but we lost everything.

Posted : January 17, 2013 2:17 pm

acantu

(@acantu)

Posts: 722

Prominent Member

Did you have a backup of the database?

Posted : January 17, 2013 11:20 pm

lic08

(@lic08)

Posts: 286

Reputable Member

Really acantu? You have experienced a database crashed, start from scratch, added new data into database and then merged back old database after recovery? that would be cool if that was possible.

Posted : February 26, 2013 1:17 am

acantu

(@acantu)

Posts: 722

Prominent Member

lic08 said:

Really acantu? You have experienced a database crashed, start from scratch, added new data into database and then merged back old database after recovery? that would be cool if that was possible.

Not quick sure what you are talking about. First, you would restore your database with backups, which we run nightly. Then once it is restored, you can start using it with new data.

Posted : February 26, 2013 7:38 am

C J Torontow

(@cjtorontow)

Posts: 45

Trusted Member

Topic starter

In our case we experienced complete data loss. We were unable to recover any data from our back ups which were not really back ups since they proved to be useless. We were able to rebuild some clinical data from our lab data and from scanned documents.

A small consolation was that we use MQIC which helped us complete UDS reporting but all of our chart notes were lost.

Posted : February 26, 2013 7:46 am

acantu

(@acantu)

Posts: 722

Prominent Member

cjtorontow said:

In our case we experienced complete data loss. We were unable to recover any data from our back ups which were not really back ups since they proved to be useless. We were able to rebuild some clinical data from our lab data and from scanned documents.

A small consolation was that we use MQIC which helped us complete UDS reporting but all of our chart notes were lost.

Very interesting, I do tests twice a year, take the backups and even restore it onto different servers. I have never had an issue.

Posted : February 26, 2013 7:54 am

C J Torontow

(@cjtorontow)

Posts: 45

Trusted Member

Topic starter

Count your blessings. We had a back up/ recovery system in place but it was not deployed properly.

Posted : February 26, 2013 8:17 am

acantu

(@acantu)

Posts: 722

Prominent Member

cjtorontow said:

Count your blessings. We had a back up/ recovery system in place but it was not deployed properly.

Ouch...

Posted : February 26, 2013 8:20 am

lic08

(@lic08)

Posts: 286

Reputable Member

I misinterpreted the question. I thought the question was to merge old data that was recovered from old database into a new running production. But if you are just talking about recovering a database from backup due to corruption, i experienced it a couple of times. The database got corrupted from an upgrade and a backup database was used to recover. The best thing i ever did was to ask GE for a test license so i can recover a production database into a test environment. That way you know your backup works.

Posted : February 27, 2013 1:17 am

acantu

(@acantu)

Posts: 722

Prominent Member

lic08 said:

I misinterpreted the question. I thought the question was to merge old data that was recovered from old database into a new running production. But if you are just talking about recovering a database from backup due to corruption, i experienced it a couple of times. The database got corrupted from an upgrade and a backup database was used to recover. The best thing i ever did was to ask GE for a test license so i can recover a production database into a test environment. That way you know your backup works.

No prob. Yes, that is the best way. Testing it every now and then if a great benefit. Makes you feel a little at ease.

Posted : February 27, 2013 1:22 am

chews on straws

(@jwollard)

Posts: 46

Trusted Member

We run two enviroments.

Production and Test

We do a monthly restore of our data to the TEST-SQL server.

This lets our developers have a playground and lets us confirm DR options. -cjtorontow if you have had a data loss, you should implement this as mandatory monthly maintenance from your IT folks.

Posted : May 7, 2013 12:52 am

nonageyer

(@nonageyer)

Posts: 50

Trusted Member

Is anyone using their transaction log to keep their reporting server or test environment up to date in case a fail-over is needed?

Posted : October 30, 2013 3:02 am

Mitch Kwiatkowski

(@mitch)

Posts: 111

Estimable Member

We use log shipping from our production environment to a backup environment at a different datacenter. I believe it runs every 5 minutes. Our IT Director implemented it about a year ago, and it's worked really well.

Posted : October 30, 2013 5:01 am

Page 1 / 2 Next

24 Forums
9,940 Topics
39.9 K Posts
1 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