Home | Concept/Dataflow | Usage | Typical Scenarios | Troubleshoot

Description

This tool leverages the currently available options that Azure platform has to provide an integrated and automated solution to back up the SQL Azure databases.

References

Title Link
Business Continuity in SQL Azure http://msdn.microsoft.com/en-us/library/windowsazure/hh852669.aspx
SQL Azure Backup and Restore Strategy http://social.technet.microsoft.com/wiki/contents/articles/1792.sql-azure-backup-and-restore-strategy.aspx
How to Use Data-Tier Application Import and Export with SQL Azure http://social.technet.microsoft.com/wiki/contents/articles/2639.aspx
Copying Databases in SQL Azure http://msdn.microsoft.com/en-us/library/windowsazure/ff951624.aspx

Architecture
The solution architecture will have the following characteristics and component structure.

image003.png

The Execution Tool

This execution tool is a command line tool. It is responsible for running operations, logging, progress information collection, retention processing and etc. Ops team can use any existing scheduling mechanism to schedule the periodical running of this tool. Through command line arguments, the corresponding information needed for the operation can be specified.

The Admin Tool

The Admin Tool is a GUI tool. It is responsible for configurations only. The configuration or profile as called in the data protector toolset is a shared file between the execution tool and the admin tool. A typical scenario would be firstly creating/editing/testing/saving the profile in the admin tool and then use the execution tool to run the backup/restore tasks.

Last edited Nov 2, 2012 at 9:26 AM by jack4it, version 12