Manually Backing Up a SQL Database

Eyefinity highly recommends employing a certified operating system and network technician to advise you on recommended data backup procedures.
  1. Close OfficeMate and ExamWRITER on all of your computers.
    The integrity of your backup is severely compromised, and in some cases invalidated, if you perform a backup while OfficeMate and ExamWRITER are open.
  2. Tell your certified operating system and networking technician 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, tell your provider or technician to backup 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 backup. Copying a SQL database without using specialized SQL database management software will cause irreparable damage to the database.
  3. Tell your certified operating system and networking technician where your DATA folder is located. For information about finding your DATA folder, go to Determining the Location of Your DATA Folder.
    The DATA folder contains such files as eDocuments, electronic claims, etc. These files reside outside of your SQL databases and do not require specialized software to perform a backup.

    If you are storing eDocuments or electronic claims in a location other than the DATA folder, ensure that you also navigate to the location of these documents and back them up.