SQLite

LIST BACKUP SETTINGS

Syntax

LIST BACKUP SETTINGS

Privileges

BACKUP

Description

The LIST BACKUP SETTINGS command retrieves detailed information about the settings applied to each database previously enabled for a backup. The backup_retention setting affects the disk space needed to store backup information about a specific database. You can specify a backup_retention settings using values like 24h, 2.5h, or 2h45m. The backup_snapshot_interval specifies how often new snapshots will be created. This setting reduces the time to restore since newer snapshots will have fewer WAL frames to apply. Retention still applies to these snapshots. If you do not set a snapshot interval, a new snapshot will be created whenever retention is performed. Retention occurs every 24 hours by default.

Return

A Rowset with the following columns:

  • name: database name
  • enabled: 1 enabled, 0 disabled
  • backup_retention: retention period
  • backup_snapshot_interval: snapshot interval value

Example

> LIST BACKUP SETTINGS
------------------------|---------|------------------|--------------------------|
 name                   | enabled | backup_retention | backup_snapshot_interval |
------------------------|---------|------------------|--------------------------|
 chinook-enc.sqlite     | 1       | 24h              | NULL                     |
 chinook.sqlite         | 1       | 168h             | NULL                     |
 db space.sqlite        | 0       | NULL             | NULL                     |
 db1.sqlite             | 1       | 168h             | NULL                     |
 dbempty.sqlite         | 1       | 24h              | NULL                     |
 encdb.sqlite           | 1       | 168h             | NULL                     |
 encdb2.sqlite          | 1       | 24h              | NULL                     |
 test-blob-10x10.sqlite | 0       | NULL             | NULL                     |
 wrongdb5.sqlite        | 0       | 24h              | NULL                     |
 wrongdb9.sqlite        | 0       | NULL             | NULL                     |
------------------------|---------|------------------|--------------------------|
Previous
APPLY BACKUP SETTINGS