Restoring Databases

This section tells you how to restore database files and includes the following topics:

Restoring Access Databases Files

If you need to restore data from a backup, ensure that your staff is properly trained to restore data. If you are not familiar with your restoration procedures, contact your certified operating system and networking technician or the manufacturer of your backup media.

  1. Close OfficeMate and ExamWRITER on all of your computers.
  2. Follow the instructions in your backup program to restore your DATA folder to its proper location. For information about finding the proper location of your DATA folder, go to Determining the Location of Your DATA Folder.

    The DATA folder contains the Access databases and such files as eDocuments, electronic claims, etc.

    If you are storing eDocuments or electronic claims in a location other than the DATA folder, ensure that you restore those files to their proper locations.

Restoring SQL Database Files

If you need to restore data from a backup, ensure that your staff is properly trained to restore data. If you are not familiar with your restoration procedures, contact your certified operating system and networking technician or the manufacturer of your backup media.

  1. Close OfficeMate and ExamWRITER on all of your computers.
  2. Follow the instructions in your backup program to restore the SQL server instance and database name. For information about finding your SQL server instance and database name, go to Determining Your SQL Database Server & Name. Additionally, restore the audit database if you are using version 10.0 or above.

    SQL databases cannot be treated like other files within Windows. SQL databases require such specialized software as SQL Server Management Studio or Veritas Backup Exec with Agent for Applications and Databases to ensure a complete and valid restoration. Copying a SQL database without using specialized SQL database management software will cause irreparable damage to the database.

  3. Follow the instructions in your backup program to restore your DATA folder to its proper location. For information about finding the proper location of your DATA folder, go to Determining the Location of Your DATA Folder.

    The DATA folder contains such files as eDocuments, electronic claims, etc. If you are storing eDocuments or electronic claims in a location other than the DATA folder, ensure that you restore those files to their proper locations.