Quick summary
- Granular restore capabilities allow teams to recover only the data they need – entire databases, specific tables, or targeted query results — eliminating the need for full restores and minimizing downtime.
- With an innovative storage tier and global search functionality in their toolkit, engineering teams can implement secure, efficient live database restores directly into running instances, saving time and resources during critical recovery scenarios.
- Unlike traditional snapshot-based solutions that require full instance restores, Eon’s approach reduces costs and operational overhead by enabling targeted restores without provisioning temporary environments.
Engineering teams often need to conduct a live database restore to address critical scenarios – whether it’s recovering from accidental data deletion, patching specific tables impacted by data corruption, or quickly restoring lost information during a security incident. Eon’s granular restore capabilities empower enterprises to implement live database restore workflows securely and efficiently.
For teams seeking to minimize downtime and prevent disruption to ongoing operations, the ability to implement a live database restore can be imperative, particularly with mission-critical workloads that require the ability to quickly recover data from backups. With Eon, engineering teams can restore entire databases, individual tables, or even targeted query results directly into running database instances.
Database restores with existing cloud backup providers
Legacy cloud backup solutions rely heavily on cloud snapshots for database backup and restore. But traditional cloud snapshots are ultimately just "black boxes" that necessitate a full restore of the entire database instance, even when only specific data needs to be recovered. Not only is this approach time-consuming and outdated, but it also incurs high operational and cloud storage compute power and costs, as teams must provision temporary environments and process large amounts of unused data. Existing cloud backup solutions are simply inadequate for scenarios requiring rapid, granular recovery, and are prone to leave organizations vulnerable to prolonged downtime and increased costs.
The Eon Storage Tier, built from the ground up for data protection
Eon’s global database search allows users to find tables among all their cloud environments which can then be queried without first restoring them
Eon solves the challenges of live database restores by leveraging its queryable storage tier and granular restore capabilities. These solutions enable operators to precisely recover only the data they need—whether it’s an entire database, specific tables, or targeted query results—without requiring a full restore. These critical operations can be carried out either manually by a user via the Eon console, or programmatically via the Eon API.
This streamlined approach eliminates the inefficiencies of traditional snapshot-based solutions, reducing recovery time and resource overhead. With Eon, users can implement faster, more secure database restore workflows, ensuring that backups can be restored within timeframes that align with their operational and business requirements. It offers teams an unprecedented level of flexibility and efficiency, empowering them to maintain productivity and meet critical recovery objectives with ease.
Live database restore with Eon - how does it work?
Eon allows for global search of database schemas by leveraging SQL queries of both SQL and NoSQL databases as if they are live, running, database instances. This is made possible by the Eon storage tier. When data is backed up to Eon, it is compressed, deduplicated, and stored in Eon’s cloud storage layer, engineered from the ground up with data-protection in mind. Structured data stored in the Eon Storage Tier is queryable without the need to perform full database restores. In fact, no compute or storage resources are needed prior to querying.
How it works
- Run a SQL query to retrieve desired data
Using the Eon Database Explorer, teams can query the Eon Storage Tier directly, without restoring a full database. Since query results can be written to an S3 bucket, you can go as granular as a single row all the way up to an entire database.
- Query results are copied to S3
The results of your Database Explorer query will be securely written to a predefined S3 bucket in a customer-managed restore account. Since you control this bucket entirely, you can ensure encryption and access configuration of the bucket meet your organization’s security requirements.
- Insert restored data into live DB using a bastion host
Now that the granular restore results are sitting in object storage in your own cloud environment, you can securely access them and restore them to a live running database with a bastion compute resource running in your own secure perimeter. No need to share credentials with 3rd parties.
And that’s all there is to it!
Since all the above operations demonstrated in the Eon console are also available as part of our well-documented REST API, developers and operators alike can develop complex workflows, automate restores using CI/CD pipelines, and even integrate these capabilities into running applications.
Better backups for a brighter cloud future
Eon’s global search and granular restore capabilities open up a world of possibilities for our customers. Live database restore is just one of the indispensable features enabled by this fundamental component of Eon’s Cloud Backup Posture management platform – and it’s only the beginning.
Do you see a way you could use our Global Search or Granular Restore? Let's connect!
