Medinotes Data Recovery

Medical Office computer crashed,  The backups were not being monitored so we only have a partial backup (Backup Exec) from a week before the crash.  Medinotes stores data in two huge files: medics.db and medics.log both of which are bigger than 150gb. The partial backup has a complete medics.db file and about 60% of the medics.log

Is there a way to: extract data from medics.db or rebuild a medics.log

Windows 2003 Server Standard Edition SP2
medinotes 5.4.13
Symantec Backup Exec 11d v 11.0
Tony LopezAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Davis McCarnOwnerCommented:
Unless you have the original password(s) for the DB file, it may be impossible to use the backup:
http://www.experts-exchange.com/Database/Sybase/Q_27059935.html

How did the original computer crash and have you considered trying to revive it?
Tony LopezAuthor Commented:
We found a solution, the .log file is a transaction log from Sybase SQL (for roll back, etc) and thus can be cleared and restarted by execution of the dbeng9 command. We are testing this result but it appears to have solved the problem. We are still attempting to recover the original server and it may yet yield results. Thanks for your help.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tony LopezAuthor Commented:
Thank the Lord that the medics.db was intact and only the medics.log was corrupted. They are using the backup to recover missing documents.
OnsiteComputerDoctorCommented:
Any ideas how to schedule a backup in Medinotes?  My new client had a similar issue with complete loss of patient charts for the past 6 months.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Disaster Recovery

From novice to tech pro — start learning today.