SQL Azure的备份和放大器;恢复策略 [英] SQL Azure Backup & Restore strategy

问题描述

我们有一个基于Web（ASP.NET MVC）应用程序，它使用SQL Server 2008为它的数据库。

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

我们所采用的策略在很大程度上受到听取金佰利特里普（可以看这里做了网络直播的影响：<一href=\"https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventId=1032278589&Country$c$c=US\">https://msevents.microsoft.com/CUI/EventDetail.aspx?culture=en-US&EventId=1032278589&Country$c$c=US).

问：

由于我们正在研究移动数据库到SQL Azure的，我想知道是否有人已实施类似的备份和放大器; SQL Azure的内恢复策略。

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?

感谢有这方面的帮助。

推荐答案

备份/恢复是在SQL Azure中完全不同的动物作为传统的备份/恢复的命令不可用。看到这篇文章的SQL Azure的备份和恢复策略一个很好的概述，然后阅读在SQL Azure中复制数据库。也看看展鹏的（测试版）的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.

修改：添加一个新的博客帖子今天出现（2011年9月29日）参考：<一href=\"http://blogs.msdn.com/b/davidmcg/archive/2011/09/29/data-backup-strategies-for-windows-and-sql-azure.aspx\">Data对于Windows和SQL Azure的备份策略

EDIT: Adding a reference to a new blog post that appeared today (Sept 29, 2011): Data backup strategies for Windows and SQL Azure

这篇关于SQL Azure的备份和放大器;恢复策略的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！