dbForge SQL Azure Backup is an easy GUI tool for creating backup copies of
SQL Azure database to local drive, SQL Server, or Azure Blob Storage for development
or archive purposes.
In short, this product allows you to easily create backups as a set of T-SQL scripts
packed into ZIP archive, or just copy cloud database to on-premise SQL Server. SQL
Azure Backup consists of 4 components:
Our backup is just a simple ZIP archive with T-SQL scripts, which you can run with
any tool like SSMS or sqlcmd. This guarantees that you can restore the database
in any environment.
Unlike transmitting data from SQL Azure to your local PC, you don't have to pay
when SQL Azure and the deployed service are in the same region. Thus you'll have
to pay only for storing backups on Blob Storage. Moreover, our engine does not require
temporary disk space and consumes only 20Mb of RAM, what reduces charges for average
disk space usage.
The maximum ZIP compression of T-SQL scripts yields fairly small .zip file, which
is even smaller than the original database .mdf file compressed with ZIP, or compressed
backup .bak file. Storing such small files on Blob Storage will significantly reduce
The backup consists of three T-SQL scripts: create database itself, create database
objects, fill tables with data. All scripts are compatible with any SQL Server (Azure/2005/2008/2011),
thus you can execute them via any tool, like SSMS or sqlcmd.
You can configure the service for Windows Azure to periodically make backup of a
database, what releases you from manual labour. You can specify the lifetime of
a backup file so that the service will delete them to free up the space on Blob
Storage. This will save your money on storing relevant backups only.
When you use dbForge SQL Azure Backup, Microsoft charges you for:
The prices listed here are guidelines, you should see Microsoft's Azure Pricing
Overview for up-to-date costs.
Prices are correct as of 14 Sep 2011.
Need more than a sole tool?
Try SQL Server Development IDE
If you are an SQL Server MVP,
send us a link to your Microsoft MVP profile and get a free
licence for any SQL Server product!
You might be also interested in:
SQL Server management tools: