使用 Amazon EC2 将 SQL Server 备份移动到异地存储？
从基于 Amazon EC2 的服务器获取 SQL Server 备份的最佳实践有哪些？我每晚都有一份创建备份的工作，但我仍然需要将它们移至“异地”。所以我真的问两个问题（1）是否有示例脚本（BAT 等）可以获取文件并将它们移动（FTP？）到另一台服务器，（2）是否有其他我可以采取的 EC2 特定选项看看？
What are some of the best practices available for taking SQL Server backups from an Amazon EC2 based server??? I have a nightly job that creates the backups but I still need to move them "off-site". So I'm really asking two question (1) are there sample scripts (BAT and otherwise) that can take the files and move them (FTP?) to another server and (2) are there any other EC2 specific options that I can take a look at?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您应该考虑两部分方法。
Amazon S3 分布在三个不同的数据中心，并提供11 个 9 的持久性 - 事实上，亚马逊倒闭的可能性比你的数据不可用的可能性更大。您可以根据丢失该时段数据的损失程度，按计划将数据备份到 S3：例如，如果丢失一天的数据不是什么大问题，也许您可以每晚备份一次。您询问了 EC2 特定的选项； EBS 快照会自动保存到 S3，它们是确保 EBS 磁盘持久性的最佳实践的一部分。
因为您永远不可能丢失 S3 上的数据，所以下一个最可能的问题是“Amazon 倒闭”或“Amazon 不允许我访问我的数据”。您可以考虑其他云提供商、传统托管提供商、您自己的现场存储等。天空确实是选项的限制（如果您找不到几个，请搜索 StackOverflow - 没有 S3 替代品）不幸的是，由除亚马逊之外的任何人托管）所以我不会在这里讨论这一点，但在考虑您需要执行的频率时，值得权衡您对发生这种情况的可能性的看法以及您需要付出的努力才能使您的数据再次有用AWS 外备份。
在 AWS 之外运行服务的人们可以轻松实现这一点，因为他们可以异地备份到 S3！
You should look at a two part approach.
Amazon S3 is distributed across three different data centers and offers durability of 11 9s - realistically there's more chance of Amazon going out of business than your data being unavailable. You could back up your data to S3 on a schedule based on how much it would hurt to lose that period's worth of data: e.g. if losing a day of data isn't a big deal, perhaps you back up nightly. You asked about EC2-specific options; EBS snapshots are automatically saved to S3, and they are part of the best practice for ensuring durability of EBS disks.
Because you're never likely to lose data on S3, the next most likely problem is "Amazon goes out of business", or "Amazon does not let me access my data". You can consider either another cloud provider, a traditional hosting provider, your own on-site storage, etc. The sky is really the limit on options (search StackOverflow if you can't come up with a handful - there is no S3-alternative hosted by anyone but Amazon unfortunately) so I won't cover that here, but it's worth weighing up your perception of the likelihood of this happening and the effort it would take you to make your data useful again when considering how frequently you need to do the off-AWS backup.
People who run services outside of AWS have it so easy, because they can just off-site back up to S3!
看看 SQL Backup Master，它可以进行数据库备份并将其移动到 Amazon S3、Dropbox、FTP 等。
Take a look at SQL Backup Master, which can take database backups and move them to Amazon S3, Dropbox, FTP, etc.
任何适用于 SQLServer 的标准备份工具都应该可以工作。但我同意 crb 的观点，即 S3（无论是否使用 EBS 快照）应该是第一道防线。
Any standard backup tool for SQLServer should work. But I agree with crb that S3 (using EBS snapshots or not) should be the first line of defense.