Back-Up and Recovery

To prevent losing data, please get in the habit of making regular system back-ups at the end of each day or work cycle. It's also very important to remember to store a copy of your back-up file (.BAK), OEM installer (.MSI) and serial number on media or another computer so you can get to it in case your main computer goes down.

Backing-Up Database

Under the Utilities menu on the Administration pad is an option to "Back-Up Database". Use this command to produce your nightly back-up file. It will create a file with a ".BAK" extension in the directory of your choosing.

* Note: If you choose a back-up file destination other than the default, you may receive an "Access Denied" or other error when doing a Back-up or Restore. This is most likely because the local SQL Server account has not been added to the list of accounts used to control access to the directory your writing to or reading from. To correct problem, locate target directory then right click. Select "Security" tab then add SQL Server account with full permissions. See these step-by-step instructions.

*Note 2: never attempt a Restore without first completing a successful back-up on the target directory. When a Restore fails it leaves database in maintenance mode and all users are locked-out. This can be difficult to undo.

Restoring Database

Back-up files generated by the "Back-Up" command can be read back-in using the "Restore" command. This will re-attach your data file and bring system back to where it left off.

*Note 1: never attempt a Restore without first completing a successful back-up on the target directory. When a Restore fails it leaves database in maintenance mode and users are locked-out. This can be difficult to undo.

*Note 2: please be warned that doing a Restore will completely overwrite the currently installed database.

How to Recover RepairShopPro

Copy your nightly back-ups to media or other computer not used for production. If main computer goes down and needs to be replaced or re-mapped, please do the following when computer comes back up: