Veritas NetBackup™ for SQLite Administrator's Guide

Last Published:
Product(s): NetBackup & Alta Data Protection (9.0.0.1, 9.0)

Performing SQLite backups

Prerequisites

Before you perform the backups, you must meet the following prerequisites:

  • Ensure that versions of the SQLite agent and NetBackup are same. If you upgrade NetBackup to newer version, then you must upgrade the agent version also.

  • Ensure that the user has administrator (Windows) or root (Linux) access.

  • (Windows) Set the NetBackup\bin directory in the user variable path.

  • Configure the DataStore policy from the NetBackup Administration Console.

  • (LVM) Verify that there is enough space for the snapshot in the volume group, and then set the snapshot size in nbsqlite.conf file or by the command line.

    Note:

    Ensure that the snapshot size is 110% of the file size that you want to backup.

  • Set the following parameters in the nbsqlite.conf file:

    • SQLITE_DB_PATH

    • MASTER_SERVER_NAME

    • POLICY_NAME

    • SCHEDULE_NAME

    • (Linux) SNAPSHOT_SIZE

To run backup

  1. Configure the parameters in the nbsqlite.conf file or on the nbsqlite command line.
  2. Run the following command:

    nbsqlite -o backup

    -S master_server_name

    -P policy_name

    -s schedule_name

    (Linux) -z snapshot_size

    -d sqlitedb_db_path

Note:

Ensure that the SQLite agent and NetBackup are of same version for successful backup and restore operations.

Scheduling the SQLite backups from the NetBackup

You can schedule SQLite backups from the NetBackup Administration Console using the DataStore policy to call a backup script.

For more information, see https://www.veritas.com/support/en_US/article.100041699