Lakehouse Research Base

Sep 4, 2025 · Databases

Recovering Deleted Databases, Tables, and Partitions in StarRocks

This guide explains how to recover accidentally dropped databases, tables, and partitions in StarRocks using the RECOVER command, covering the 1-day default retention window, configuration options, limitations like TRUNCATE and FORCE drops, and practical step-by-step examples with renaming strategies.