Confirm ability to restore retired partitions from S3 back into a cluster and document (Timebox: 2 days)

**Describe the task**
Motivation for restoring retired partitions is to be able to access historical data in a sandboxed environment for debugging or re-exporting data in a different format.

**Acceptance Criteria**
- [ ] Be able manually restore archived partition data to a crunchydb cluster
- [ ] Prevent or document how to avoid restored data being re-archived

**Additional context**
- Add any other context about the task here.
- Or here

Start by locating the existing S3 partition-archiving workflow and CrunchyDB cluster configuration. Test manually restoring archived partition data in a sandbox, then document the restore procedure and how to prevent or identify restored data being re-archived; done means both acceptance criteria are demonstrated.

Written by the indexing model from the issue text.