SqlBak has an API that allows it to integrate with other applications and services. This article explains how to integrate SqlBak and Zabbix. Sending job results to Zabbix 1. Export the template to Zabbix. It contains items for job results (status, date, backup type). Create a JSON file with the following content: { “zabbix_export”: { … Read more
Documentation for the SqlBak product is currently under development. We apologize for any inconvenience.
While the documentation is being finalized, you can reach out to us through our support service, and we will strive to respond to your inquiry within a few hours.
Below is a list of articles from our blog where you can find useful materials on using SqlBak:
SqlBak enables the execution of SQL scripts and Windows batch scripts within backup or maintenance jobs. By default, script execution is disabled for security reasons. When attempting to add a script to a job, an error message may appear:
Execution of <script type> is prohibited. To allow script execution, please enable the corresponding option in the SqlBak App security settings.
Currently, SqlBak has access to all files and folders on Google Drive. Now, SqlBak will request access only to the files and folders on Google Drive created by SqlBak.
If a database that should be backed up via SqlBak is not particularly large, then there is no need to set compression options in a specific way. It is recommended to use the default values.
The features below are designed to fine-tune compression for highly loaded systems and large databases.
If you specify a password in the “Encrypt compressed files” section, then the backup files will be encrypted.
This guide contains recommendations for setting up a SqlBak backup job. This information has been developed and collected over years of interaction with SqlBak users. There will be no theory and formulas, only practical advice.
Note that these practices are not the only solutions. They are suitable in most cases, but can be fundamentally wrong under various circumstances.
Let’s consider the steps that are used to set up a backup job.
Differential and transaction log backups are available only for local SQL Server connections. If you backup SQL Server using SqlBak, then you can add differential or transaction log backups to your backup plan in the “Advanced backup schedule” settings.
In one database management system, there can be multiple databases. When creating a backup job, you can choose which databases specifically need to be backed up. The backup of each database will be made independently from the other databases and placed in a separate archive.
SqlBak supports sending to 16 different storage types. In one job, you can specify multiple backup storage locations, and for each storage location, you can specify the duration of backup storage on it.
