您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

使用 Azure 扩展对 SQL Server 2008 和 SQL Server 2008 R2 的支持Extend support for SQL Server 2008 and SQL Server 2008 R2 with Azure

适用于:是,Azure VM 上的 SQL ServerAPPLIES TO: yesSQL Server on Azure VM

SQL Server 2008 和 SQL Server 2008 R2 的支持生命周期均已终止 (EOS)SQL Server 2008 and SQL Server 2008 R2 have both reached the end of their support (EOS) life cycle. 因为许多客户仍在使用这两个版本,所以我们提供几个选项使它们继续获得支持。Because many customers are still using both versions, we're providing several options to continue getting support. 你可以将本地 SQL Server 实例迁移到 Azure 虚拟机 (VM)、迁移到 Azure SQL 数据库或者就保留在本地,然后购买扩展安全更新。You can migrate your on-premises SQL Server instances to Azure virtual machines (VMs), migrate to Azure SQL Database, or stay on-premises and purchase extended security updates.

与托管实例不同,迁移到 Azure VM 不需要重新认证应用程序。Unlike with a managed instance, migrating to an Azure VM does not require recertifying your applications. 与停留在本地不同,迁移到 Azure VM 会使你收到免费的扩展安全修补程序。And unlike with staying on-premises, you'll receive free extended security patches by migrating to an Azure VM.

本文的其余部分介绍将 SQL Server 实例迁移到 Azure VM 的注意事项。The rest of this article provides considerations for migrating your SQL Server instance to an Azure VM.

若要详细了解终止支持选项,请参阅终止支持For more information about end of support options, see End of support.

设置Provisioning

Azure 市场上提供了一个用于 Windows Server 2008 R2 映像的即用即付 SQL Server 2008 R2。There is a pay-as-you-go SQL Server 2008 R2 on Windows Server 2008 R2 image available on Azure Marketplace.

使用 SQL Server 2008 的客户需要自行安装或升级到 SQL Server 2008 R2。Customers who are on SQL Server 2008 will need to either self-install or upgrade to SQL Server 2008 R2. 同样,使用 Windows Server 2008 的客户需要从自定义 VHD 部署 VM 或者升级到 Windows Server 2008 R2。Likewise, customers on Windows Server 2008 will need to either deploy their VM from a custom VHD or upgrade to Windows Server 2008 R2.

通过 Azure 市场部署的映像预装了 SQL IaaS 扩展。Images deployed through Azure Marketplace come with the SQL IaaS extension pre-installed. 具备 SQL IaaS 扩展才能拥有灵活的许可和自动修补功能。The SQL IaaS extension is a requirement for flexible licensing and automated patching. 部署自行安装的 VM 的客户需要手动安装 SQL IaaS 扩展。Customers who deploy self-installed VMs will need to manually install the SQL IaaS extension. Windows Server 2008 不支持 SQL IaaS 扩展。The SQL IaaS extension is not supported on Windows Server 2008.

备注

虽然 SQL Server 的“创建”和“管理”边栏选项卡可用于 Azure 门户中的 SQL Server 2008 R2 映像,但不支持以下功能 :自动备份、Azure Key Vault 集成、R 服务以及存储配置。Although the SQL Server Create and Manage blades will work with the SQL Server 2008 R2 image in the Azure portal, the following features are not supported: Automatic backups, Azure Key Vault integration, R Services, and storage configuration.

授权Licensing

即用即付的 SQL Server 2008 R2 部署可以转换为 Azure 混合权益Pay-as-you-go SQL Server 2008 R2 deployments can convert to Azure Hybrid Benefit.

若要将基于软件保障 (SA) 的许可证转换为即用即付许可证,客户应向 SQL VM 资源提供程序注册。To convert a Software Assurance (SA)-based license to pay-as-you-go, customers should register with the SQL VM resource provider. 完成注册后,SQL 许可证类型可在 Azure 混合权益与即用即付之间互换。After that registration, the SQL license type will be interchangeable between Azure Hybrid Benefit and pay-as-you-go.

可以向 SQL VM 资源提供程序注册在 Azure VM 上自行安装的 SQL Server 2008 或 SQL Server 2008 R2 实例,并将它们的许可证类型转换为即用即付。Self-installed SQL Server 2008 or SQL Server 2008 R2 instances on an Azure VM can register with the SQL VM resource provider and convert their license type to pay-as-you-go.

迁移Migration

你可以使用手动备份/还原方法将 EOS SQL Server 实例迁移到 Azure VM。You can migrate EOS SQL Server instances to an Azure VM with manual backup/restore methods. 这是从本地迁移到 Azure VM 最常见的方法。This is the most common migration method from on-premises to an Azure VM.

Azure Site RecoveryAzure Site Recovery

对于批量迁移,我们建议使用 Azure Site Recovery 服务。For bulk migrations, we recommend the Azure Site Recovery service. 通过 Azure Site Recovery,客户可以复制整个 VM,包括从本地到 Azure VM 的 SQL Server。With Azure Site Recovery, customers can replicate the whole VM, including SQL Server from on-premises to Azure VM.

SQL Server 需要应用一致性 Azure Site Recovery 快照以确保恢复。SQL Server requires app-consistent Azure Site Recovery snapshots to guarantee recovery. Azure Site Recovery 支持间隔最短 1 小时的应用一致性快照。Azure Site Recovery supports app-consistent snapshots with a minimum 1-hour interval. 在 Azure Site Recovery 迁移中,SQL Server 可能的最短恢复点目标 (RPO) 为 1 小时。The minimum recovery point objective (RPO) possible for SQL Server with Azure Site Recovery migrations is 1 hour. 恢复时间目标 (RTO) 为 2 小时加 SQL Server 恢复时间。The recovery time objective (RTO) is 2 hours plus SQL Server recovery time.

数据库迁移服务Database Migration Service

如果客户要通过将 SQL Server 升级到 2012 版或更高版本的方式从本地迁移到 Azure VM,可以选择使用数据库迁移服务The Database Migration Service is an option for customers if they're migrating from on-premises to an Azure VM by upgrading SQL Server to the 2012 version or later.

灾难恢复Disaster recovery

Azure VM 上 EOS SQL Server 的灾难恢复解决方案如下:Disaster recovery solutions for EOS SQL Server on an Azure VM are as follows:

  • SQL Server 备份:使用 Azure 备份,通过 15 分钟的 RPO 和时点恢复,帮助保护 EOS SQL Server 2008 和 2008 R2 不受勒索软件侵害、不遭到意外删除和损坏。SQL Server backups: Use Azure Backup to help protect your EOS SQL Server 2008 and 2008 R2 against ransomware, accidental deletion, and corruption with 15-min RPO and point-in-time recovery. 有关详细信息,请参阅本文For more details, see this article.
  • 日志传送:你可以在另一个区域或 Azure 区域中创建一个日志传送副本,并通过连续还原来减少 RTO。Log shipping: You can create a log shipping replica in another zone or Azure region with continuous restores to reduce the RTO. 需要手动配置日志传送。You need to manually configure log shipping.
  • Azure Site Recovery:你可以通过 Azure Site Recovery 复制在区域和区域之间复制 VM。Azure Site Recovery: You can replicate your VM between zones and regions through Azure Site Recovery replication. SQL Server 需要应用一致性快照以确保执行灾难恢复。SQL Server requires app-consistent snapshots to guarantee recovery in case of a disaster. Azure Site Recovery 为 EOS SQL Server 灾难恢复提供至少 1 小时的 RPO 和 2 小时(加上 SQL Server 恢复时间)的 RTO。Azure Site Recovery offers a minimum 1-hour RPO and a 2-hour (plus SQL Server recovery time) RTO for EOS SQL Server disaster recovery.

安全修补Security patching

在向 SQL VM 资源提供程序注册 SQL Server VM 后,通过“Microsoft 更新”通道传递 SQL Server VM 的扩展安全更新程序。Extended security updates for SQL Server VMs are delivered through the Microsoft Update channels after the SQL Server VM has been registered with the SQL VM resource provider. 修补程序可手动下载,也可自动下载。Patches can be downloaded manually or automatically.

自动修补 :默认处于启用状态。Automated patching is enabled by default. Azure 可以通过自动修补来自动修补 SQL Server 和操作系统。Automated patching allows Azure to automatically patch SQL Server and the operating system. 如果安装了 SQL Server IaaS 扩展,你可以指定维护时段是星期几,并指定它的时间和持续时间。You can specify a day of the week, time, and duration for a maintenance window if the SQL Server IaaS extension is installed. Azure 会在维护时段进行修补。Azure performs patching in this maintenance window. 维护时段计划使用 VM 的时间区域设置。The maintenance window schedule uses the VM locale for time. 有关详细信息,请参阅 Azure 虚拟机上 SQL Server 的自动修补For more information, see Automated patching for SQL Server on Azure Virtual Machines.

后续步骤Next steps

将 SQL Server VM 迁移到 Azure:Migrate your SQL Server VM to Azure:

开始使用 Azure 虚拟机上的 SQL Server:Get started with SQL Server on Azure Virtual Machines:

获取有关 SQL Server VM 的常见问题的解答:Get answers to commonly asked questions about SQL Server VMs:

详细了解终止支持选项和扩展安全更新:Find out more about end of support options, and extended security updates: