我们有一个基于 Web (ASP.NET MVC) 的应用程序，它使用 SQL Server 2008 作为其数据库。
因为数据对我们（和我们的客户）很重要，所以我们有一个备份和备份系统。恢复策略到位，简而言之，如下所示：
-Weekly: Full database backup
-Nightly: Differential backup
-Hourly: Log backup
我们使用的策略很大程度上受到收听 Kimberly Tripp 所做的网络广播的影响（可以在此处查看：https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventId=1032278589&CountryCode=US）。
问题：
由于我们正在考虑将数据库迁移到 SQL Azure，我想知道是否有人已经实施了类似的备份和备份。 SQL Azure 中的恢复策略。
有没有人在尝试实施备份和备份时遇到过任何已知问题？使用 Azure 恢复策略？
感谢您对此的任何帮助。
We have a web based (ASP.NET MVC) application that uses SQL Server 2008 for its database.
Because the data is important to us (and our clients), we have a Backup & Restore strategy in place which, in a nutshell, looks like this:
-Weekly: Full database backup
-Nightly: Differential backup
-Hourly: Log backup
The strategy we use was greatly influenced by listening to a webcast done by Kimberly Tripp (which can be viewed here: https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventId=1032278589&CountryCode=US).
Question:
Since we are looking into moving the database to SQL Azure, I wanted to know if anyone has put in place a similar Backup & Restore strategy within SQL Azure.
Has anyone encountered any known issues with trying to put in place a Backup & Restore strategy with Azure?
Thanks for any help on this.
发布评论
评论（5）
备份/恢复在 SQL Azure 中是完全不同的动物，因为传统的备份/恢复命令不可用。请参阅文章 SQL Azure 备份和还原策略以获得良好的概述，然后阅读复制 SQL Azure 中的数据库。另请查看 redgate 的（测试版）第三方 SQL Azure 备份工具 。
编辑：添加对今天（2011 年 9 月 29 日）出现的新博客文章的引用：Windows 和 SQL Azure 的数据备份策略
Backup/restore is a whole different animal in SQL Azure as the traditional backup/restore commands are not available. See the article SQL Azure Backup and Restore Strategy for a good overview and then read Copying Databases in SQL Azure. Also take a look at redgate's (beta) third party tool for SQL Azure Backup.
EDIT: Adding a reference to a new blog post that appeared today (Sept 29, 2011): Data backup strategies for Windows and SQL Azure
除了 Joe 提到的选项之外，您还可以使用 此处提到的 DAC 。它有点过时了，因为您现在可以从门户中的 Blob 存储导入/导出 BACPAC 文件。
In addition to the options that Joe has mentioned you can also use DAC as mentioned here. It is a little out of date as you can now import/export BACPAC files from blob storage in the portal.
Redgate 提供了一个免费工具，用于将数据库从 SQL Azure 备份和还原到 SQL Server 或 Azure Blob 存储：
Redgate offers a free tool to backup and restore a database from SQL Azure to SQL Server or Azure Blob Storage:
我写了一篇博客文章，介绍如何使用一些免费的命令行工具和 Windows 任务计划程序将 SQL Azure DB 备份到博客文件，应该可以为您节省一些金钱和麻烦:-)
https://iainhunter.wordpress.com/2012/08/21/sql-azure-disaster-recovery/
I wrote a blog post on backing up your SQL Azure DB to a blog file using nothing more complex than some free command line tools and the windows task scheduler, should save you some money and hassle :-)
https://iainhunter.wordpress.com/2012/08/21/sql-azure-disaster-recovery/
codeplex 上有一个项目可以让辅助角色充当备份代理。
There is one project on codeplex that is making possible to have a worker role to be acting as a backup agent.