Sign inTry Free

Back Up and Restore Data

Note

The process described below of raising a Support ticket for data recovery will remain valid till March 31, 2025. After that, it will be replaced with Continuous Backups

Backups are automatically taken at scheduled intervals by the system. These system-created backups are not directly accessible by users. To restore from these default system-created backups, you need to raise a support ticket.

Note

This topic applies to database backups made using the BACKUP DATABASE command.

Incremental backups cannot be made on unlimited storage databases.

Unlimited storage databases can be restored (attached) to any point in time using PITR, which is not discussed in this topic. See Database Storage for information on PITR.

Caution

SingleStore does not support restoring database backups from a newer version of SingleStore into an older version.

Databases on a secondary workspace to which the primary database is being replicated cannot be backed up with the BACKUP DATABASE command.

In this section

Last modified: January 24, 2025

Was this article helpful?

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK