Medical Director & PracSoft Recovery - (CyberSecure Advanced)
Document Version: 1.0
Overview
Recovering Medical Director is treated in two parts:
- The SQL database
- ManageEzy documents
Prerequisites
- Server hardware & network must be correctly installed & configured.
- The base Medical Director/PracSoft software must be installed already.
- CyberSecure ADVANCED must be installed already.
- All Windows® updates should be installed prior to following this tutorial.
- Recover ManageEzy data
- Recover ManageEzy backup set to original location
- Recover MD3/PS SQL data
- Recover SQL backup data through software to a temporary location
- Install SQL management studio
- Put each database in single-user mode:
- Right-click each database and select [Properties]
- Go to [Options] in the left pane
- Scroll down to [State] and change [Restrict Access] from MULTI_USER to SINGLE_USER
- Restore their database backup. The following
[Options] must be set:
- Overwrite the existing database
- Now restore the .BAK database file into SQL server
Common issues and solutions
| Issue/error message | Solution |
|---|---|
| [Microsoft][ODBC SQL Server Driver][SQL Server] The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. | The recovery model of the database must be changed using the SQL Management Studio software. |
| [Microsoft][ODBC SQL Server Driver][SQL Server] BACKUP LOG cannot be performed because there is no current database backup. | This means there is no coherent database backup on which to base the transaction logs. Running a database backup will correct this issue. |

