What is the best way to perform a nightly, automatic backup of a SQL Azure database? I make random backups when I need to before changes using the "create database xxx as copy of yyy" technique but I need something automatic.
I've considered using the Import/Export feature in SQL Azure Labs with a script that runs nightly to export to my laptop
https://www.sqlazurelabs.com/ImportExport.aspx
That sure seems a bit clunky for a service that's supposed to be enterprise ready, though.
Are there better ways to perform SQL Azure backups?