免費試用 *Internet Service Required

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# (42.8 KB)
 
 
 
 
 
(7)
1,423 次
加到我的最愛
2011/6/1
E-mail Twitter del.icio.us Digg Facebook
向 Microsoft 報告內容不當
登入以發問

  • 回應問題 | 隱藏
    I can't build the solution.
    1 Posts | 最後一篇文章 四月 24, 2013
  • 回應問題 | 隱藏
    this project is not working
    1 Posts | 最後一篇文章 十月 04, 2012
    • 已撰寫 十月 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?
  • 回應問題 | 隱藏
    Why does the stuck in the loop for queue message ?
    3 Posts | 最後一篇文章 九月 10, 2011
    • 已撰寫 八月 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.
    • 已撰寫 九月 10, 2011 
      Just stumbled over the same problem. Azure beginner :-(
    • 已撰寫 九月 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);