Enzo Cloud Backup
Use Enzo Cloud Backup to create backups of SQL Database
(including federations), Azure Tables and run
database scripts on a schedule. You can use the built-in scheduler to
backup your databases and Azure Tables too. This tool also allows you to restore
Azure Tables into a SQL environment so you can query your Azure Table records
with T-SQL and run reports!
Uses
- Prevent data loss of your SQL Databases and Azure Tables by performing full backups
- Recover from unintentional data loss (truncated tables...).)
- Migrate Azure-ready SQL Server databases in SQL Azure
- Backup customer databases that use schema separation (multitenant SaaS model)
- Backup SQL Database federations and restore them
- Run database maintenance scripts entirely in the cloud
- Integrate backup and restore capabilities in your code with the Enzo Backup API
Screen Shots
Scheduled Jobs:
Backup a SQL Database Federation:
View Database Details (Federations):
I want to...
| |
Use the Community Edition |
> |
Download the backup tool and start using it! |
| |
Try the Advanced Edition |
> |
Download the backup tool, and email us to
request a 15-day trial license key for the advanced edition. |
| |
Purchase the Advanced Edition |
> |
Download the backup tool, click on Buy Now and follow the instructions. |
| |
Upgrade to the Advanced Edition |
> |
Click on Buy Now and follow the instructions. |
Features
Not all the features are available with the Community Edition.
See below for a list of features available.
|
|
Community Edition |
Advanced Edition |
| |
Backup SQL Database |
Yes (1) |
Yes |
| |
Backup SQL Database Federations |
No |
Yes |
| |
Backup SQL Server |
Yes (1,2) |
Yes (2) |
| |
Backup Azure Tables |
Yes (1,3) |
Yes |
| |
Backup Templates |
No |
Yes |
| |
Restore |
Yes (3) |
Yes |
| |
Schedule in Azure |
Yes |
Yes |
| |
Database Scripts |
Yes (5) |
Yes |
| |
Run Cloud Agents |
Yes (4) |
Yes |
| |
Advertising Free |
No |
Yes |
| |
SMTP Alerts |
No |
Yes |
| |
.NET Backup API Included |
No |
Yes |
| |
Multiple Storage Accounts |
No |
Yes |
(1) Limited to 50 backup operations per month; performance limitations apply
(2) Limited support (must be SQL Database compliant)
(3) Cannot copy Azure Tables into a SQL environment
(4) Limited to 1 cloud agent (small or extra small)
(5) Scripts limited to 250 characters
Details
The Enzo Backup for SQL Azure works as a local windows application allowing you to issue backup and restore
requests for your SQL Databases. You can backup and restore from Blob storage or from your local file system.
Backup files are compressed and contain both schema and data of a database.
Backing up a SQL Server database is only supported if the database was initially restored from a SQL Azure database.
For example tables without a Primary Key will not be backed up. This feature allows developers to backup a SQL
Database and restore it on premise using SQL Server to work on it. Once the work completed, developers can backup
the updated database from SQL Server and restore it back into SQL Azure.
The backup tool will also allow backing up a single schema, as opposed to an
entire database. This is useful for sharding and multitenant scenarios in which a single database hosts multiple customers, each with its own schema.
As such, backup files can be created for a single customer.
The backup tool also supports backing up and restoring SQL Database Federations.
You can restore federated roots, federated members individually, and even
restore them on a SQL Server database for inspection.
A command-line utility can be used to execute backup operations of a SQL Database through a
third-party scheduler. The command-line utility
supports most the options offered through the user interface. t the options offered through the user interface.
Enzo Backup also offers a built-in scheduler allowing to schedule one-time or recurring backup operations. The jobs
are designed to run entirely in the cloud.
The product uses highly sophisticated backup and restore techniques to avoid transient errors and typical network
latency issues. Lab tests show that a 50MB database can be backed up in 2 minutes and restored in 3 minutes.
The product will backup many object types, including tables, triggers, stored procedures, views, functions, spatial data types,
spatial indexes, constraints and foreign keys, user-defined types, user-defined statistics and more.
This release also allows you backup and restore Azure Tables. Azure Tables can be backed up on a local file, in blobs or
copied into a SQL environment (SQL Server or SQL Database). The backup operation of Azure Tables can be filtered. By default, all
entities and their properties are backed up. However you can specify that only certain properties need to be backed up, and even
provide a filter to limit the number of entities that are backed up. The restore operation can be performed against any SQL Server
database version and can either create tables automatically or call custom stored procedures that can receive and transform the data.
This release also allows you to create and run database maintenance scripts, from your local machine or from the cloud agent. These scripts can be executed
on a schedule, before and after Azure Table restore operation, or manually. This feature can be used to rebuild indexes on a periodic basis for example.
Limitations
While User Defined Types are supported, the product does not restore Table-Type Constraints. However user-table constraints are
fully supported.
Certain limitations apply when restoring federated databases; see the help
section for additional information.
In this release the product does not offer differential backup support.
Support
You can obtain assistance with configuration and general support by email.