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

适用于: Azure VM 上的 SQL Server

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 Standard Pay-in-Advance Offer 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 Services 和存储配置。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.

迁移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(包括 SQL Server)从本地复制到 Azure VM。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,可以选用 Azure 数据库迁移服务The Azure 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. 对于 EOS SQL Server 灾难恢复,Azure Site Recovery 提供最小 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

可以手动或自动下载修补程序。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: