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!


  Buy Now   Download     Online Help     Backup API     Release Notes     Technical Details  


   Download Enzo Cloud Backup 3.0 Preview (with Blob Backup!)

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, and email us to request a 15-day trial license key for the advanced edition.
   Purchase Advanced Edition  >  Download the backup tool, click on Buy Now and follow the instructions.
   Upgrade to 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.