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 http://msdn.microsoft.com/en-us/library/windowsazure/ff951624.aspx
2. Use BCP command line utility to backup and restore your data on SQL Azure to/from your local disk http://blogs.msdn.com/b/sqlazure/archive/2010/05/21/10014019.aspx
3. SQL Data Sync http://msdn.microsoft.com/en-us/library/windowsazure/hh456371.aspx

No comments:

Post a Comment