When The Edge with MSSQL is installed by The Edge support team, a back-up utility is configured to make a local copy of your SQL data each evening. This utility creates the actual files that you will need to back up.
By default, it will be stored in C:\Program Data\ajsllc\EdgeSQLBackup. For this to work, the server or primary workstation hosting the SQL database must be powered on. Turning the PC off will cause the backup to fail, and your data will not be backed up.
Now you are ready to configure your backup mechanism to back up the following files:
- The MSSQL database backup files as described above. They are located in the C:\Program Data\ajsllc\EdgeSQLBackup folder. If you do not see this file, contact The Edge Support Team immediately.
- The Edge photos located in the C:\ProgramData\ajsllc\edge\photos folder.
- The appraisal template files located in a subfolder of the shared folder, called APPR.
NOTE: For example, they may be stored in the C:\ProgramData\ajsllc\edge\appr folder.
- The Edge license is stored in the MSSQL database and need not be backed up separately.
The paths above are typical. To verify your paths, go to Administrative > Configuration. The Database Settings > Production Settings section of this window holds the name and location of your database folder.
Be sure you are backing up the database and photo library from Production, not Test
Over time, the backup folder, C:\Program Data\ajsllc\EdgeSQLBackup, will be filled with a number of old SQL backups that could overwhelm your hard drive. We recommend that you periodically delete some of the older backup files to free up storage space. Just be sure your external backup is current. Most stores do this weekly.