How to schedule SQLite backups from NetBackup

Description

You can initiate the SQLite backups in NetBackup using the DataStore policy to call a backup script.

Solution

This article provides an sample script to schedule an automatic backup using the NetBackup Administration Console. You can copy the sample script to a preferred location, but ensure that the path is a white listed path. Use this script when configuring DataStore policy for the backup.

Note: You must modify the sample script according to your environment.

Steps 

To backup the SQLite database using the backup script

1. Download the sample backup script and copy it to a preferred location.
2. Rename the script sqlite_backup_script.txt to sqlite_backup.
3. In the NetBackup Administration Console, create an automatic full backup schedule in Policy>Schedule>Attributes tab.
4. Under Backup Selections tab, provide the path to the modified script as backup selection.
5. Under the Client tab, specify the SQLite server.
6. Specify the parameters in the nbsqlite.conf file.                                                            For more information, see the NetBackup for SQLite Administrator's Guide.
7. Run the backup using the NetBackup Administration Console.

Applies to
NetBackup for SQLite version 3.10.0 and later.

Operating systems
Red Hat Enterprise Linux (RHEL) 6.8 and later.
SUSE Enterprise Linux Server 12 SP4 and later.

Disclaimer: Please note that the script attached to this article is provided as is and is a sample script only. The script is not supported by NetBackup Technical support.
It is the responsibility of the customer to modify the script to take into account specific requirements and variables in his/her environment.