# Database operations and recovery controls

Understand database sleep, capacity, access, backup, and recovery before applying a change.

Source: https://docs.rumata.dev/guides/controls-database-operations
Reviewed: 2026-09-06

## Before you start

- Open the named screen in Rumata. Available controls may depend on your account, permissions, and resource state.

<a id="operations"></a>

## Database Operations

Open [System Explorer](https://docs.rumata.dev/guides/controls-preview#navigation) → [Database](https://docs.rumata.dev/guides/controls-database-tables#table-browser) → [Operations](https://docs.rumata.dev/guides/controls-database-operations#operations). The capacity and idle-hibernation controls also appear in the extended [Overview](https://docs.rumata.dev/guides/controls-overview#snapshot).

| Control | What it does |
| --- | --- |
| About Database operations / About Capacity & recovery | Open an explanation of the panel and the meaning of its measurements. |
| Idle hibernation | Open the sleep-timer settings for an on-demand database. These settings are saved separately from capacity. |
| Manage capacity | Review allocated storage, actual data size, and your plan maximum before applying resources. |
| Manage access | Open access management for the database resource. |
| Status and recovery indicators | Show readiness, whether writes are allowed, plan retention, and verified recovery availability. Waiting or unavailable information is not a measured zero. |

![Database operations and Capacity & recovery panels.](https://docs.rumata.dev/media/manual/database-operations.jpg)

Reference capture from the separate Sabai Talk Thai application (September 8, 2026). Use [Operations](https://docs.rumata.dev/guides/controls-database-operations#operations) to review database health, capacity, and recovery controls. Inspect the figures before changing a setting.

<a id="sleep"></a>

## Database idle hibernation dialog

A sleeping database wakes automatically on the next connection. This sleep timer is different from your [development machine](https://docs.rumata.dev/guides/development#machine)’s idle timer.

| Control | What it does |
| --- | --- |
| Quick sleep timer choices | Select a preset duration within the account’s allowed range. The default is marked; available choices depend on the plan. |
| Days / Hours / Minutes | Enter a custom whole-minute duration. Read the minimum and maximum shown in the dialog. |
| Database will sleep after | Preview the total duration you are about to save. |
| Save sleep timer | Save a valid changed duration. Disabled when the value is unchanged, invalid, unavailable, or already being saved. |
| Cancel / Close | Leave without applying the pending duration. |

![Database idle hibernation dialog with quick choices, custom duration, Cancel, and Save sleep timer.](https://docs.rumata.dev/media/manual/hibernation.jpg)

Reference capture from the separate Sabai Talk Thai application (September 8, 2026). Opening the dialog does not change the timer. Cancel closes it; [Save sleep timer](https://docs.rumata.dev/guides/controls-database-operations#sleep) applies your choice. This capture leaves the existing setting unchanged.

<a id="capacity"></a>

## Update hosted database capacity dialog

Choose the total usable storage you need. Enter the full amount, not just the increase. You can increase capacity but cannot shrink it here.

| Control | What it does |
| --- | --- |
| New database capacity number / slider | Choose a whole-MiB value between the current allocation and plan maximum. A slider appears only when capacity can be increased. |
| Increase capacity to … | Request the selected larger total capacity. Expansion may wait for platform storage and continue automatically. |
| Apply current plan resources | Reapply the plan’s CPU, memory, and connection limits even when storage is already at its maximum. |
| Switch database to always on | Apply always-on operation when a plan upgrade makes it available. The database wakes if necessary and stays running. |
| Switch to always on and increase to … | Apply both the available always-on entitlement and your larger storage selection. |
| Close | Dismiss the dialog without requesting a capacity change. |

<a id="backup-recovery"></a>

## Data protection and recovery

Recovery replaces the current database with its state at a selected time. Changes after that time will be discarded. Review the account scope and selected time before starting.

| Control | What it does |
| --- | --- |
| Create backup | Start an on-demand backup while the database remains online. Disabled until the database is ready or while another backup/recovery operation is active. |
| Recover database | Open the recovery form. Available only with a verified recovery window and no active operation. |
| Recovery point / date-time picker | Choose a time inside the displayed verified window. Dates use the timezone named on the screen. |
| Confirmation | Type RESTORE exactly to acknowledge that later changes will be discarded. |
| Start recovery | Start preparing and validating a replacement database. Connections switch after validation; the old database is then removed. The button stays disabled until the time and confirmation are valid. |
| Cancel / Close | Dismiss the form without initiating recovery. |
| Operation history | Follow pending, running, completed, or failed operations. This is a status list rather than another action. |

## Related guides

- [Database editor controls](https://docs.rumata.dev/guides/controls-database)
- [Understand plans and usage](https://docs.rumata.dev/guides/billing)
- [Groups and permissions](https://docs.rumata.dev/guides/collaboration)