Creates a consistent SQLite backup using the native backup API. Old backups beyond the retention count are automatically pruned.