QuestDB
EnterpriseCustomersDocsBlog
8.3.1
  • Roadmap
Download
  • Introduction
  • Quick start
  • Why QuestDB?
  • Schema Design Essentials
  • Migrate from InfluxDB
  • Ingestion Reference
  • Query & SQL Reference
    • Query & SQL Overview
    • PGWire Clients
      • Overview
      • Python
      • Go
      • Java
      • Rust
      • Node.js
      • .NET
      • PHP
      • R
    • Data types
    • SQL execution order
    • SQL Syntax
      • ADD USER
      • ALTER
      • ASSUME SERVICE ACCOUNT
      • CANCEL QUERY
      • CHECKPOINT
      • COPY
      • CREATE
      • DROP
      • EXPLAIN
      • EXIT SERVICE ACCOUNT
      • GRANT
      • INSERT
      • REFRESH MATERIALIZED VIEW
      • REINDEX
      • RENAME TABLE
      • REMOVE USER
      • REVOKE
      • SELECT
      • SHOW
      • SNAPSHOT
      • TRUNCATE TABLE
      • UNION EXCEPT INTERSECT
      • UPDATE
      • VACUUM TABLE
    • Functions
    • Operators
  • Deployment
  • Operations
  • Guides & Tutorials
  • Concepts
  • Third-party Tools
  • Troubleshooting
  • Query & SQL Reference
  • SQL Syntax
  • SNAPSHOT

SNAPSHOT keyword

This is a deprecated syntax to prepare the database for a full backup or a filesystem (disk) snapshot. SNAPSHOT SQL syntax has been superceded by CHECKPOINT SQL syntax

For a detailed guide backup creation and restoration? Check out our Backup and Restore guide!

Syntax​

Flow chart showing the syntax of the SNAPSHOT keyword

Edit this page
Previous
SHOW
Next
TRUNCATE TABLE
  • Syntax

Need a hand? Join our vibrant public Slack and Discourse forum communities.

Copyright © 2025 QuestDB
PrivacyTerms