CREATE MILESTONE

Syntax

CREATE MILESTONE [milestone_name] [FOR remote_database_name]

Arguments

Remarks

• While the milestone is being created, SingleStore uploads the remote database's local workspace data to remote storage that has not yet been synced.

• If milestone_name is not specified, a name containing the current timestamp is automatically generated.

• If milestone_name already exists, the restore point used by the existing milestone is overwritten with the restore point of the new milestone.

• If remote_database_name is not specified, the context database (specified with the USE command) is used.

• Refer to the Permission Matrix for the required permission.

Example

The following example creates a new milestone on the existing unlimited storage database bottomless_db:

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).