SQL Azure 备份
有人想出了一个备份 SQL Azure 数据库的好方法吗？
这两种方法似乎是SSIS 或BCP。 SSIS 看起来需要本地安装 MS SQL 2008，但我没有。 BCP 看起来更有前途，但到目前为止我还没有找到任何将它与 SQL Azure 一起使用的示例。
Has anyone come up with a good way to do backups of SQL Azure databases?
The two approaches seem to be SSIS or BCP. SSIS looks like it requires a local install of MS SQL 2008 which I don't have. BCP looks a bit more promising but I haven't managed to find any examples of using it with SQL Azure as of yet.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（9）
在 PDC09 上，他们发布了 SQL Azure 数据同步，这是一个早期预览版，旨在让您的本地 SQL Server 与 Azure SQL Server 保持同步。
就维护等数据库备份而言，这当然是您通过微软管理的 Azure 付费的服务的一部分。
同步框架团队有一个博客，讨论有关 Azure 和本地数据库之间数据同步的许多问题 - http ://blogs.msdn.com/sync/default.aspx
At the PDC09 they announced SQL Azure Data Sync, which was an early preview that is designed to let you keep your local SQL Server in sync with an Azure SQL Server.
In terms of database backups for maintenance etc, then of course that is part of the service you pay for with Azure that MS manage.
The sync framework team have a blog on a number of issues surrounding data syncronisation between Azure and a local DB - http://blogs.msdn.com/sync/default.aspx
我个人最喜欢的解决方案是使用 Azure 移动服务进行夜间备份和备份。从 SQL Azure 导出到 Azure 存储中托管的 .bacpac 文件。此解决方案不需要第 3 方工具，不需要 bcp 或 powershell，是 100% 云，并且不需要本地托管 SQL Server 实例来下载/复制/备份任何内容。
大约有 8 个不同的步骤，但它们都非常简单：http://geekswithblogs.net/BenBarreth/archive/2013/04/15/how-to-create-a-nightly-backup-of-your- sql-azure.aspx
My personal favorite solution is to use Azure Mobile Services to do a nightly backup & export from SQL Azure to a .bacpac file hosted in Azure Storage. This solution doesn't require a 3rd party tool, no bcp or powershell, is 100% cloud and doesn't require a local hosted SQL Server instance to download/copy/backup anything.
There are about 8 different steps, but they're all pretty easy: http://geekswithblogs.net/BenBarreth/archive/2013/04/15/how-to-create-a-nightly-backup-of-your-sql-azure.aspx
SQL Azure 现在提供对 Azure blob 存储中 bacpac 文件的自动和可调度备份
http://blogs.msdn.com/b/sql-bi-sap-cloud-crm_all_in_one_place/archive/2013/07/24/sql-azure-automated-database-export.aspx
我们使用它进行夜间备份并让该工具保留最近的 14 个备份。
SQL Azure now offers automated and schedulable backups to bacpac files in Azure blob storage
http://blogs.msdn.com/b/sql-bi-sap-cloud-crm_all_in_one_place/archive/2013/07/24/sql-azure-automated-database-export.aspx
We use this to make nightly backups and have the tool keep the most recent 14 backups.
Enzo Backup for SQL Azure 现已推出（预计于 10 月 1 日全面发布）：http://www.bluesyntax.net/ backup.aspx
您可以备份具有事务一致性的数据库并在以后恢复它；它将备份存储在云端或本地。它还包括调度功能。
Enzo Backup for SQL Azure is available (full release expected October 1st): http://www.bluesyntax.net/backup.aspx
You can backup a database with transactional consistency and restore it at a later time; it stores its backups in the cloud, or on-premise. It also includes a scheduling capability.
我花了一些时间使用 BCP 并让它正常工作。必须逐个表进行备份/恢复有点烦人，但我会编写脚本，直到 Microsoft 引入适当的 SQL Azure 备份功能（预计将在 2010 年上半年推出）
。 ：
恢复：
I spent some time with BCP and got it working acceptably. It's a bit annoying to have to do the backup/restore table-by-table but I'll script it and that will do until Microsoft bring in a proper SQL Azure backup feature which is supposedly going to be the first half of 2010.
Backup:
Restore:
我们使用 Red Gate 工具设置了一个简单的解决方案，但它也需要本地 SQL 实例： http://mooneyblog.mmdbsolutions.com/index.php/2011/01/11/simple-database-backups-with-sql-azure
We set up a simple solution using Red Gate tools, but it too requires a local SQL instance: http://mooneyblog.mmdbsolutions.com/index.php/2011/01/11/simple-database-backups-with-sql-azure
我正在使用 www.sqlscripter.com 生成插入/更新数据脚本（以同步我的本地数据库）。不是免费的（共享软件），但值得尝试。
I'm using www.sqlscripter.com to generate insert/update data scripts (to sync my local db). Not for free (shareware) but worth to try.
您现在可以使用 SQL Azure Copy 执行数据库备份。有关此内容的更多详细信息，请此处找到。
You can now use SQL Azure Copy to perform backups of your database. More details on this can be found here.
似乎 azurelabs 现在可以提供一些东西：
Azure Labs
相关文章
Seems that azurelabs has something to offer now:
Azure Labs
related article