Backup SQL Azure To Windows Azure Blob Storage

This samples shows how to create SQL Azure database snapshots using SQL Azure's COPY DATABASE feature and the BACPAC CTP. It demonstrates pracical use of startup tasks for Azure roles and solves the burning problem of backup/restore for SQL Azure to a certain extent.

C# (43.5 KB)
 
 
 
 
 
4.5 Star
(8)
3,556 times
Add to favorites
6/1/2011
E-mail Twitter del.icio.us Digg Facebook
Report abuse to Microsoft
Sign in to ask a question

  • Answer the question | Hide
    I can't build the solution.
    1 Posts | Last post April 24, 2013
  • Answer the question | Hide
    this project is not working
    1 Posts | Last post October 04, 2012
    • Written October 04, 2012 
      Now this project is not working. Microsoft.SqlServer.DAC does not support import/export anymore. From where to get the Microsoft.SqlServer.DAC dll which has import/export APIs?
  • Answer the question | Hide
    Why does the stuck in the loop for queue message ?
    3 Posts | Last post September 10, 2011
    • Written August 29, 2011 
      var msg = this.BackupTriggerQueue.GetMessage(TimeSpan.FromMinutes(10));
if (msg != null)
{
   Trace.WriteLine("Received backup trigger message.", "Information");

I always receive null in msg and the rest of the code never executes. Why queue is being used and from where the message will be added in it. I don't see that code.
    • Written September 10, 2011 
      Just stumbled over the same problem. Azure beginner :-(
    • Written September 10, 2011 
      I found a workaround, I simply removed the queue (uncomment/delete the part at the start of the while loop) and instead of sleeping 5 seconds, set the sleep to the period you want to wait between backups.

One day in my case, so Thread.Sleep(1000 * 60 * 60 * 24);