On this page
Prior to using this command, the
enable_ engine variable must be set to
ON (the default value).
Records a milestone, which is a named point to which you can restore an unlimited storage database.
You must have
CREATE TABLE permission in a database to create a milestone.
CREATE MILESTONE [milestone_
A quoted string that is the name of the milestone to create.
While the milestone is being created, SingleStore uploads the remote database's local cluster data to remote storage that has not yet been synced.
milestone_is not specified, a name containing the current timestamp is automatically generated.
milestone_already exists, the restore point used by the existing milestone is overwritten with the restore point of the new milestone.
remote_is not specified, the context database (specified with the
USEcommand) is used.
Refer to the Permission Matrix for the required permission.
The following example creates a new milestone on the existing unlimited storage database
CREATE MILESTONE "m" FOR bottomless_db;
For a basic walkthrough of creating milestones, see Attach an Unlimited Storage Database Using Point-in-Time Recovery (PITR).
Last modified: January 9, 2023