Best practice medical restore guide

Synopsis

This guide describes the procedure for restoring the Best Practice medical software database from an approved CyberSecure installation.

CyberSecure takes a consistent backup of the best practice SQL database via Windows Volume Shadow Services (VSS) and so is not the same process as the application-level backup within Best Practice.

The file type stored by CyberSecure are the raw MDF files and so need to be placed back into the exact SQL database location for “BPSINSTANCE” on the Best Practice machine – this can vary between installations.

Process

  1. Ensure Best Practice is installed and up to date
  2. Restore the backed up data through the CyberSecure agent to a temporary location
  3. Stop the following services:
    1. SQL Server (BPSINSTANCE)
    2. SQL Server Browser
    3. SQL Server VSS Writer
  4. The default location of database files is:
    C:\Program Files\Microsoft SQL Server\MSSQL10_50.BPSINSTANCE\MSSQL\DATA

    This may be different on your server

    Copy the restored MDF files from the temporary location over the existing BPINSTANCE SQL server files EXCEPT for the following files:

    1. master.mdf
    2. mastlog.ldf
    3. model.mdf
    4. modellog.ldf
    5. MSDBData.mdf
    6. MSDBLog.ldf
  5. Start the services:
    1. SQL Server (BPSINSTANCE)
    2. SQL Server Browser
    3. SQL Server VSS Writer
  6. Log into Best Practice
  7. Check some data within Best Practice to ensure correctness