Backups, Point-in-Time Recovery, and Disaster Planning in Blanca's Builder

Blanca's Builder automatically performs daily full backups of your database and stores transaction logs continuously. This dual approach ensures comprehensive data protection, allowing you to restore your database to a specific point in time within our retention period. These backups are stored securely across multiple availability zones, offering high resilience against regional outages.

Should a data incident occur, our point-in-time recovery (PITR) feature enables you to revert your database to almost any second within the last 30 days. This granular control is crucial for recovering from accidental deletions, data corruption, or other unforeseen events. Accessing and initiating a PITR operation is conveniently managed through your Blanca's Builder dashboard, providing an intuitive interface for critical recovery actions.

Beyond data backups, Blanca's Builder meticulously tracks all database schema changes through its built-in migration history. Every modification to your database structure – such as adding tables, altering columns, or defining relationships – is recorded and versioned. This history allows you to understand how your database schema has evolved over time, which is invaluable for debugging and compliance.

While Blanca's Builder provides robust schema versioning, direct rollback of schema changes is generally handled through redeploying a previous version of your application code that corresponds to an earlier schema state. It's important to test schema changes thoroughly in a staging environment before applying them to production to minimize risks.

We understand that you may need to export your data for various reasons, including compliance, external analytics, or migrating to another platform. Blanca's Builder offers a straightforward process to export your entire database (or specific tables) in common formats like CSV or SQL dump files. This functionality ensures that you retain full control and ownership of your data at all times.

To export your data, navigate to the 'Database' section in your project dashboard and select the 'Export' option. Follow the on-screen prompts to choose your desired format and scope of export. We recommend performing regular data exports in addition to our automated backups, especially for critical datasets, to maintain an independent copy.

Even with automated backups, having a clear disaster recovery (DR) runbook is essential. For small teams, this doesn't need to be overly complex. Start by identifying your critical systems and data. What are the absolute essentials that must be restored first? Prioritize services based on their impact on your core business operations.

Your runbook should outline step-by-step procedures, including who is responsible for each action, contact information for key personnel, and expected recovery time objectives (RTOs) and recovery point objectives (RPOs). Practice your DR plan regularly, perhaps quarterly, to identify bottlenecks and ensure all team members know their roles. This proactive approach significantly reduces panic and downtime during actual incidents. Blanca's Builder's recovery features integrate seamlessly into such a plan, providing the technical means to execute your data restoration strategy.