Regular backups of the data should always be part of every security concept. If you wish to create backups directly on the SQL server, you should also include the Password Safe databases. If no central backups are carried out at the SQL level, you can create backup profiles using the AdminClient. The backups themselves will then be generated on the SQL Server.
Difference between an incremental and full backup
A complete backup always saves all data in a database. An incremental backup also creates a complete image of the database as the first step. In future, only the changes since the backup created at the beginning will be saved. This saves both time and memory capacity.
It is recommended to run an incremental backup every hour. In addition, a full backup should be created once a week.
Managing backup schedule
Creating backup schedule
You can create a new schedule via the ribbon. This is facilitated by a wizard. All the information entered under “Backup settings”:https://help.passwordsafe.de/v8/830/en/topic/backup-einstellungen will be used by default.
First, assign a profile name and select the desired databases. You also need to specify the directory for the backups.
Now set the time interval for creating backups. A preview on the right will show when the backups will be created in future. An end date can be optionally entered.
In the advanced settings, you can configure whether the backup should be activated directly. It is also possible to specify whether to create incremental backups. If the date and time are added to the file name, a new backup is created with each run. If this is not done, the last backup is always overwritten. The service user can be used to create the backup or a service user with the name and password can be specified.
The backups are executed by the SQL server in the background. If an error occurs, it is displayed “orange” in the backup list. Under all backups, information about the error is displayed if the SQL server issues any. A backup will be automatically deactivated if it does not run 5x in a row. This will be marked in the list in red. The schedule cannot be reactivated directly. You need to open it and adjust it.
Other backup actions
A selected schedule can be deleted via the ribbon. The wizard of a schedule can be called up by double-clicking on it to change it. In addition, a backup can be started directly via the ribbon at any time. The backup service must be running for this purpose. You can also display this in the history.
Restoring data from a backup
Restoring data from backups is performed using the database module. Data can be restored only into existing databases. First select the required data base. You can now select Insert in the ribbon.
If necessary, firstly enter login data for the user that logs in to the SQL server – although the service user is generally used here. Now select the backup file. All the backups contained in the file will be displayed. Click on Restore to restore the backup into the existing database.