Thursday, October 4, 2012

Backup Options for Your SQL Azure Database

SQL Azure guarantees “Monthly Availability” of 99.9% during a calendar month, but it currently does not back up your database automatically.  Without a proper DB backup plan, your business is literally one-click away from disaster.

There are a few options you can back up your database:

1. Copy one Azure database to another
2. Use BCP command line utility to backup and restore your data on SQL Azure to/from your local disk
3. SQL Data Sync