Database Backups & Restores

Data integrity is the most critical aspect of any production application. LaunchVerse provides automated backups and Point-In-Time recovery for managed databases.

Automated Backups

By default, all production databases are configured with automated daily backups.

1. Backups are stored securely off-site in cold storage.
2. The retention period is determined by your subscription tier (e.g., 7 days for Pro, 30 days for Enterprise).
3. Backups are performed using streaming replication to ensure zero downtime or performance degradation on your primary database node during the backup window.

Manual Backups

If you are about to run a massive schema migration or deploy a high-risk application change, you can trigger a manual backup instantly.

1. Navigate to your Database in the Resources tab.
2. Click the Backups section.
3. Click Create Manual Backup.
4. The backup will be tagged and preserved indefinitely until you manually delete it.

Point-In-Time Restore

If catastrophic data loss occurs (e.g., accidentally dropping a table), you can restore your database to a previous state.

1. Navigate to the Backups section of your Database.
2. Select the specific backup snapshot you wish to restore.
3. Click Restore.

> [!CAUTION]

> Restoring a database is a destructive action that overwrites the current state of the database with the snapshot state. Any data written to the database between the time the snapshot was taken and the current time will be permanently lost.

LaunchVerse will briefly pause incoming connections, apply the snapshot, and resume traffic automatically.