使用 Azure 擴充對 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 Database,或保留內部部署並購買擴充的安全性更新。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 Marketplace 上提供一個在 Windows Server 2008 R2 映像上執行的隨用隨付 SQL Server 2008 R2There 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 Marketplace 部署的映像會隨附預先安裝的 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 Hybrid BenefitPay-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. 在完成上述註冊後,即可互換 Azure Hybrid Benefit 與隨用隨付這兩種 SQL 授權類型。After that registration, the SQL license type will be interchangeable between Azure Hybrid Benefit and pay-as-you-go.

在 Azure VM 上自行安裝的 SQL Server 2008 或 SQL Server 2008 R2 執行個體,可以向 SQL VM 資源提供者註冊,並將其授權類型轉換成隨用隨付。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 ServiceDatabase 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 Server VM 已向 SQL VM 資源提供者註冊後,會透過 Microsoft Update 通道傳遞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 patchingAutomated 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: