Medical Director & PracSoft Recovery - (CyberSecure Advanced)

Document Version: 1.0

Overview

Recovering Medical Director is treated in two parts:

  1. The SQL database
  2. ManageEzy documents

Prerequisites

  1. Recover ManageEzy data
    1. Recover ManageEzy backup set to original location
  2. Recover MD3/PS SQL data
    1. Recover SQL backup data through software to a temporary location
    2. Install SQL management studio
    3. Put each database in single-user mode:
      1. Right-click each database and select [Properties]
      2. Go to [Options] in the left pane
      3. Scroll down to [State] and change [Restrict Access] from MULTI_USER to SINGLE_USER
    4. Restore their database backup. The following [Options] must be set:
      1. Overwrite the existing database
    5. Now restore the .BAK database file into SQL server

Common issues and solutions

Issue/error messageSolution
[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.