Course contentsShow
← Cloud and Infrastructure
Lesson 424 of 2,9898. Managed DatabasesFree lesson

Manual Snapshots and Retention

Creating on-demand database snapshots for long-term retention beyond automated backup windows.

Manual Snapshots and Retention

What you'll learn: How to create on-demand database snapshots that persist beyond your automated backup windows for long-term storage and compliance needs.


Why Manual Snapshots Matter

Remember Automated Backup Configuration and Point-in-Time Recovery? Those backups follow a retention schedule—typically 7 to 35 days—and then they're automatically deleted. But what if you need to preserve a database state for months, years, or even permanently?

That's where manual snapshots come in. They're on-demand backups you create yourself, and they live forever until you explicitly delete them.

Creating Manual Snapshots

Think of automated backups as your home security camera keeping the last week's footage. Manual snapshots are like taking a special photograph you put in an album—it stays there indefinitely.

You create manual snapshots when:

  • Before major changes: deploying a risky schema update
  • Compliance requirements: quarterly or yearly data archiving
  • Development milestones: preserving a "known good" state
  • Legal holds: retaining specific data versions for audits

How Retention Works

Automated backups: Deleted automatically after your configured retention period (1-35 days typically).

Manual snapshots: Persist indefinitely—you control their lifecycle. They cost storage fees as long as they exist, so you should delete obsolete snapshots to manage costs.

Storage Considerations

Manual snapshots use the same underlying snapshot technology as automated backups, storing only incremental changes. The first snapshot is a full copy; subsequent snapshots only store deltas, making them storage-efficient.


Key Takeaway:
Manual snapshots give you permanent, on-demand database backups that survive beyond automated retention windows—essential for compliance, major changes, and long-term archival needs. You control both creation and deletion.