Hi tvo7,
First, John, thanks for those. I think the above services would be extremely helpful. Of course, I doubt they will keep on AC. They would only have on a pdf or something or paper records and give out. But, a good way to be out of the middle.
So, I would likely stay away from faxing. To fax without wasting tons of paper, you would have to use a fax server. They may be fast, but they may not, and they may not be as accurate. Plus, you are at the mercy of the receiving office getting it or saying they received it.
To answer your main question, it would be very difficult if not impossible to just have a SQL backup and go from there. You could if you had AC, but then you would restore all to AC. While a good SQL expert could probably back up a copy of just the one doctor, it sounds more complicated than it needs to be.
Even if the departing doctor purchased a license for just one year, you still have the issue of HIPAA. I suppose you could get around that as he could still come off as medical colleague of yours.
This is why, in my opinion, the best way is to have a date when he finishes, keep track of those who have already requested records, then come in with some help and just crank them out. We are able, via pdf and our system, make a pdf of the records on any patient in about three to four minutes. This would be the pdf you would want on the external drive you keep. This would be the drive you would want a few backups of. Or to send to one of John's services above. I think medicolegally, you would have to keep his patient charts still on your database as they were once patients there.
