Name

.backup — Perform a low-level copy of a database to file

Common Usage

.backup [database_name] filename

Description

The .backup command performs a low-level copy of an open or attached database to the provided filename. This command is safe to run against an active source database (although it may not succeed). If the database name is not provided, the main database will be backed up. This command is frequently used to write-back an active in-memory database to a database file.

This is the opposite of the .restore command.