Hyper-V 快照备份策略适合生产 SQL 服务器吗？
因此，Hyper-V 中的 SQL Server 2008 是受支持的配置，只要您使用固定或直通磁盘并适当增加处理器/内存设置，就应该表现良好。我的问题是我可以使用快照作为可靠的备份机制，还是应该使用经过考验且值得信赖的维护计划来进行备份？
So SQL Server 2008 in Hyper-V is a supported configuration, and should perform well as long as you use fixed or pass-through disks and increase your processor/memory settings appropriately. My question is can I use snapshots as a reliable backup mechanism, or should I use the tried and trusted maintenance plan to do my backups?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您不应使用 Hyper-V 快照作为 SQL 备份策略。坚持使用可以执行 SQL 感知备份的东西（内置的或其他方式）。
Hyper-V 快照（在我看来）应该仅在生产服务器上用于非常短期的灾难恢复。如果您正在进行升级，请先创建快照，完成后立即进行测试，然后放弃快照。此类事情应该与常规备份一起完成，而不是代替它。
如果您将 Hyper-V 快照作为唯一的备份策略，您将无法将数据库恢复到另一台服务器和服务器上。对数据库进行时间点恢复——除此之外，我确信我现在还没有考虑到其他事情。
You should NOT use Hyper-V snapshots as your backup strategy for SQL. Stick with something (built-in or otherwise) that will do SQL aware backups.
Hyper-V snapshots (in my opinion) should only be used on production servers for very short term disaster recovery. If you're doing an upgrade, do a snapshot first, immediately test when done, then ditch the snapshot. This sort of thing should be done along side your regular backups, not in place of it.
If you were to move to Hyper-V snapshots as your sole backup strategy, you'd lose the ability to restore your databse to another server & do point in time restores of the database - among other things that I'm sure I'm just not thinking of now.
不支持 Hyper-V 或任何虚拟化供应商的虚拟化快照与虚拟机中的 SQL Server 一起使用。使用快照和 SQL Server 时，您可能不会遇到任何问题，但 Microsoft 不会为从快照还原的虚拟机的 SQL Server 客户提供技术支持
http://support.microsoft.com/kb/956893/en-us
Virtualization Snapshots for Hyper-V or any virtualization vendor are not supported to use with SQL Server in a virtual machine. It is possible that you may not encounter any problems when using snapshots and SQL Server, but Microsoft will not provide technical support to SQL Server customers for a virtual machine that was restored from a snapshot
http://support.microsoft.com/kb/956893/en-us