Use the Workspace Groups path (/v1/workspaceGroups/{workspaceGroupID}/storage/retentionPeriod endpoint) in the Management API to specify the retention period (in minutes) for an unlimited storage database. The retention period specifies how long the historical information used to enable point-in-time recovery (PITR) is retained. By default, the retention period is set to 10080 minutes.

For example, the following API request sets the retention period to 7200 minutes for the workspace group with ID 058e2ed1-3000-4000-a000-512d334df903:

curl -X 'PATCH' \
  'https://api.singlestore.com/v1/workspaceGroups/058e2ed1-3000-4000-a000-512d334df903/storage/retentionPeriod' \
  -H 'accept: */*' \
  -H 'Content-Type: application/json' \
  -d '{
  "retentionPeriod": 7200
}'

Refer to Management API Reference for more information.

Once a milestone reaches the retention period, it is no longer available and does not appear in the MV_MILESTONES information schema view.

You cannot attach an unlimited storage database at a milestone or time that is not within the retention period. For example, consider that the retention period is 1440 minutes (1 day) and you create a milestone for a database dbExample on June 1. On June 3, you will not be able to attach dbExample at the milestone created on June 1 or at a point in time that occurred on June 1.