{"schemaVersion":"1","contentVersion":"2026-10-18.1","slug":"controls-database-operations","title":"Database operations and recovery controls","summary":"Understand database sleep, capacity, access, backup, and recovery before applying a change.","category":"Control reference","minutes":6,"prerequisites":["Open the named screen in Rumata. Available controls may depend on your account, permissions, and resource state."],"sections":[{"id":"operations","title":"Database Operations","blocks":[{"type":"paragraph","text":"Open [System Explorer](/guides/controls-preview#navigation) → [Database](/guides/controls-database-tables#table-browser) → [Operations](/guides/controls-database-operations#operations). The capacity and idle-hibernation controls also appear in the extended [Overview](/guides/controls-overview#snapshot)."},{"type":"table","headers":["Control","What it does"],"rows":[["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."]]}]},{"id":"sleep","title":"Database idle hibernation dialog","blocks":[{"type":"paragraph","text":"A sleeping database wakes automatically on the next connection. This sleep timer is different from your [development machine](/guides/development#machine)’s idle timer."},{"type":"table","headers":["Control","What it does"],"rows":[["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."]]}]},{"id":"capacity","title":"Update hosted database capacity dialog","blocks":[{"type":"paragraph","text":"Choose the total usable storage you need. Enter the full amount, not just the increase. You can increase capacity but cannot shrink it here."},{"type":"table","headers":["Control","What it does"],"rows":[["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."]]}]},{"id":"backup-recovery","title":"Data protection and recovery","blocks":[{"type":"paragraph","text":"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."},{"type":"table","headers":["Control","What it does"],"rows":[["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."]]}]}],"technical":[],"related":["controls-database","billing","collaboration"],"sources":["components/window/explorer/DatabaseIdleTimeoutDialog.tsx","components/window/explorer/DatabaseCapacityDialog.tsx","components/window/explorer/CapacitySelector.tsx","components/window/explorer/database/DatabaseRecoveryActions.tsx","components/window/explorer/database/database-recovery-window.ts"],"updated":"2026-09-06","audience":"general","media":[{"src":"https://docs.rumata.dev/media/manual/database-operations.jpg","width":1662,"height":789,"alt":"Database operations and Capacity & recovery panels.","caption":"Reference capture from the separate Sabai Talk Thai application (September 8, 2026). Use [Operations](/guides/controls-database-operations#operations) to review database health, capacity, and recovery controls. Inspect the figures before changing a setting.","sectionId":"operations"},{"src":"https://docs.rumata.dev/media/manual/hibernation.jpg","width":1662,"height":789,"alt":"Database idle hibernation dialog with quick choices, custom duration, Cancel, and Save sleep timer.","caption":"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](/guides/controls-database-operations#sleep) applies your choice. This capture leaves the existing setting unchanged.","sectionId":"sleep"}],"video":null,"url":"https://docs.rumata.dev/guides/controls-database-operations"}