Notifications
Clear all
Topic starter
Has anyone lost a SQL database then merged that data back into the production after recovery of the original?
Help!
Posted : October 25, 2012 2:31 am
Yes, what is the issue you are having?
Posted : December 3, 2012 1:34 am
Topic starter
Thanks for getting back, but we lost everything.
Posted : January 17, 2013 2:17 pm
Did you have a backup of the database?
Posted : January 17, 2013 11:20 pm
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
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
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
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
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
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
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
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
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
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
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
