The Backup/Restore page allows the user to backup and restore the entire Fortress database. Since Fortress uses SQL Server’s backup tool, this is merely an interface to manually create backups of the Fortress database. To automatically backup your Fortress database via a script, consult SQL Server’s backup documentation.
Fortress backup files are placed in SQL Server’s defined location for backup files.
Backup Database
In the Backup File Name field, type the name of the backup file. The input name must be a valid file name. Fortress will automatically append ".sgvbak" to the file name.
In this field, the user can add a brief description of the backup file.
Click Backup Now to start the backup.
Restore Database
The Backup List box is a list of all files in the server backup directory that are Fortress backup files. The date and time of the file are also listed.
Click Restore to restore the selected file on the server. All users must be logged off. If there are other users logged in and the Fortress server is unable to lock the database, an error message will appear and the restore will be cancelled.
When you restore a backup, it will completely overwrite all the data in the Fortress database in all repositories.
You must provide the SQL Server password in order to restore the database.
Click Delete to delete the selected backup entry from the list.
This does not delete the backup file itself from the SQL machine. You must remove these files if you want to reclaim disk space.