[Revised Apr 2006]
Restoring returns the data to what it was at the time the last backup was made. This provides recovery from corrupted or damaged data. Normally there will be no loss of script or sales data as the 'Roll forward recovery' and will re-enter for itself the work done since the last backup was made, so SoH levels will be correct.
However, orders waiting for delivery will return to what they were at time of backup, and new stock items added since the backup will be lost.
Start of month
If restoring a backup from last month, you will need to force the monthly rollover once the restore is finished.
First
On a networked system, disconnect the network cable before doing anything. to ensure that you do not accidentally affect the data on the Slaves. You may be grateful for the Slave data.
To restore
1. Put the latest backup disk in the drive.
2. From the PharmcyPro Start Menu choose Tools, Utilities, Database utilities, Restore.
- If the DB is corrupted in such a way that you cannot even get into the 'utilities' to restore, it is possible to restored directly from Windows.
- It is also possible to run the restore by using 'My Computer' to go to c:\phcypro\lotsrest.exe and click on that to run it directly.
3. Setting the choices
- Normally 'restore database' only, unless there is reason to suspect that some physical damage to the hard disk has corrupted the programs as well.
- Check that the 'Drive to restore' is set to the drive that contains the backup disk... usually D: or E: for a Zip drive.
- Accept the default choice of 'Restore database AND recover scripts', which will first restore the database as it was at time of the last backup AND re-enter for itself all work done since the backup was made using the 'Roll forward recovery'.
Note: Restore and recover scripts can take up to 20 minutes if there is a lot to restore... while waiting console yourself that it is very much faster than having to re-enter work.
If restore fails
Occasionally a faulty backup disk cannot be read. If so, try the next oldest backup disk. E.g. if this is Friday and the 'Thursday' backup disk failed then try 'Wednesday'. 'RxOne' roll forward recovery can usually recover all work right up to the last script, even if working of a backup that is up to six weeks old. However, it always best to work off the latest disk.
- If restore does not work and the script histories are still missing, but personal patient details such as name and address are all there, suspect that the year is set incorrectly.
Finally
Reconnect the network cable, if it was disconnected.
WHAT TO DO AFTER YOU HAVE RESTORED.
Restoring from backup is the last step for solving a database problem. Before you try this ALWAYS try shutting down every computer and restarting. Try a 'rebuild' on the database. Try a 'scandisk' and a 'defrag' on the hard disk. Always use the most recent backup.
Restoring from backup returns the data in your computer back to the same situation it was in when the backup was done. This data includes stock levels, cash takings, account balances and orders. This means that everything done on the computer since the last backup needs to be redone (with the possible exception of scripts).
Dispensary:
When doing a restore, if recover scripts from audit trail is ticked, and the hard disk is in good shape, 'RxOne' will re-enter any scripts since the last backup and adjust stock accordingly. This 'roll-forward recovery' is very important for Claims and means the scripts will be allocated the same script number as they originally had. RxOne may warn you to check some scripts that have unusual errors on them after the recover is finished.
If the computer is replaced or repaired the 'roll-forward-recovery' may be impossible. In which case get all scripts done since the last backup and enter them in the same order to allocate the same script numbers. This makes repeats easier a month later. Any repeats done since the last backup will need to be done also. You may need to go through the rubbish to get the 2nd part of the six part labels for this.
Claims:
If your scripts were recovered from the audit trail (as above) then there is little to do. If you had made up a claim since the last backup you will need to make it up again. If claiming by floppy disk, use the new disk not the old disk if possible.
Point of Sale:
All sales since the backup will be lost. Any stock sold will still be in stock on the stock card. There is no practical solution to this except to ensure rolling stock-takes are done regularly.
The end of day report will not balance with the money in the till.
Debtors:
'RxOne' prints a docket for each account sale, which should be retained. These will need to be re-entered to ensure you are paid. Money received on account will also need to be re-entered.
Orders:
All orders that have been delivered into stock will need to be re-entered. Creating a blank order for the supplier and adding all the items off the packing slip easily accomplishes this. When you have finished, turn off the POS sticker printer and deliver the order. Delete the print job to save labels.
Related topic