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

Azure 的 Windows 虚拟机上运行的 SQL Server 常见问题解答Frequently asked questions for SQL Server running on Windows virtual machines in Azure

本文提供有关在 Azure 的 Windows 虚拟机上运行 SQL Server 时出现的一些最常见问题的解答。This article provides answers to some of the most common questions about running SQL Server on Windows Virtual Machines in Azure.

备注

本文重点阐述在 Windows VM 上运行 SQL Server 的特定问题。This article focuses on issues specific to SQL Server on Windows VMs. 如果在 Linux VM 上运行 SQL Server,请参阅 Linux 常见问题If you are running SQL Server on Linux VMs, see the Linux FAQ.

如果本文未解决 Azure 问题,请访问 MSDN 和 Stack Overflow 上的 Azure 论坛。If your Azure issue is not addressed in this article, visit the Azure forums on MSDN and Stack Overflow. 可将问题发布到这些论坛上,或发布到 Twitter 上的 @AzureSupportYou can post your issue in these forums, or post to @AzureSupport on Twitter. 还可提交 Azure 支持请求。You also can submit an Azure support request. 若要提交支持请求,请在 Azure 支持页上,选择“获取支持” 。To submit a support request, on the Azure support page, select Get support.

映像Images

  1. 有哪些 SQL Server 虚拟机库映像可用?What SQL Server virtual machine gallery images are available?

    Azure 为所有 Windows 和 Linux 版本中的所有受支持 SQL Server 主要发行版维护虚拟机映像。Azure maintains virtual machine images for all supported major releases of SQL Server on all editions for both Windows and Linux. 有关详细信息,请参阅 Windows VM 映像Linux VM 映像的完整列表。For more information, see the complete list of Windows VM images and Linux VM images.

  2. 现有的 SQL Server 虚拟机库映像是否会更新?Are existing SQL Server virtual machine gallery images updated?

    每隔两个月,都会使用最新的 Windows 和 Linux 更新对虚拟机库中的 SQL Server 映像进行更新。Every two months, SQL Server images in the virtual machine gallery are updated with the latest Windows and Linux updates. 对于 Windows 映像,这包括 Windows 更新中标记为重要的任何更新,以及重要的 SQL Server 安全更新和 Service Pack。For Windows images, this includes any updates that are marked important in Windows Update, including important SQL Server security updates and service packs. 对于 Linux 映像,这包括最新的系统更新。For Linux images, this includes the latest system updates. Linux 和 Windows 的 SQL Server 累积更新以不同的方式进行处理。SQL Server cumulative updates are handled differently for Linux and Windows. 对于 Linux,SQL Server 累积更新也包含在刷新中。For Linux, SQL Server cumulative updates are also included in the refresh. 但目前,Windows VM 不会连同 SQL Server 或 Windows Server 累积更新一起更新。But at this time, Windows VMs are not updated with SQL Server or Windows Server cumulative updates.

  3. 是否可以从库中删除 SQL Server 虚拟机映像?Can SQL Server virtual machine images get removed from the gallery?

    是的。Yes. Azure 只为每个主要版本维护一个映像。Azure only maintains one image per major version and edition. 例如,发布新的 SQL Server Service Pack 时,Azure 会将新映像添加到该 Service Pack 的库。For example, when a new SQL Server service pack is released, Azure adds a new image to the gallery for that service pack. 先前 Service Pack 的 SQL Server 映像将立即从 Azure 门户中删除。The SQL Server image for the previous service pack is immediately removed from the Azure portal. 但是,在接下来的三个月,仍可以通过 PowerShell 预配该映像。However, it is still available for provisioning from PowerShell for the next three months. 三个月之后,先前的 Service Pack 映像不再可用。After three months, the previous service pack image is no longer available. 如果 SQL Server 版本由于生命周期结束而不受支持,则也会应用此删除策略。This removal policy would also apply if a SQL Server version becomes unsupported when it reaches the end of its lifecycle.

  4. 是否可以部署 Azure 门户中不可见的较旧的 SQL Server 映像?Is it possible to deploy an older image of SQL Server that is not visible in the Azure portal?

    是的,使用 PowerShell。Yes, by using PowerShell. 有关使用 PowerShell 部署 SQL Server VM 的详细信息,请参阅如何使用 Azure PowerShell 预配 SQL Server 虚拟机For more information about deploying SQL Server VMs using PowerShell, see How to provision SQL Server virtual machines with Azure PowerShell.

  5. 能否创建 SQL Server VM 的一般化 Azure SQL Server marketplace 映像, 并使用它来部署 Vm?Can I create a generalized Azure SQL Server marketplace image of my SQL Server VM and use it to deploy VMs?

    是, 但你必须随后向SQL Server VM 资源提供程序注册每个 SQL Server VM , 以便在门户中管理 SQL Server VM, 并使用自动修补和自动备份等功能。Yes, but you must then register each SQL Server VM with the SQL Server VM resource provider to manage your SQL Server VM in the portal, as well as utilize features such as automated patching and automatic backups. 向资源提供程序注册时, 还需要指定每个 SQL Server VM 的许可证类型。When registering with the resource provider, you will also need to specify the license type for each SQL Server VM.

  6. 我是否可以使用我自己的 VHD 来部署 SQL Server VM?Can I use my own VHD to deploy a SQL Server VM?

    是, 但你必须随后向SQL Server VM 资源提供程序注册每个 SQL Server VM , 以便在门户中管理 SQL Server VM, 并使用自动修补和自动备份等功能。Yes, but you must then register each SQL Server VM with the SQL Server VM resource provider to manage your SQL Server VM in the portal, as well as utilize features such as automated patching and automatic backups.

  7. 是否可以设置虚拟机库中未显示的配置(例如 Windows 2008 R2 + SQL Server 2012)?Is it possible to set up configurations not shown in the virtual machine gallery (For example Windows 2008 R2 + SQL Server 2012)?

    否。No. 对于包含 SQL Server 的虚拟机图库映像,必须通过 Azure 门户或 PowerShell 选择提供的某个映像。For virtual machine gallery images that include SQL Server, you must select one of the provided images either through the Azure portal or via PowerShell. 但是, 你可以向其部署 Windows VM 和自行安装 SQL Server。However, you have the ability to deploy a Windows VM and self-install SQL Server to it. 然后, 必须向SQL Server VM 资源提供程序注册你的 SQL Server VM , 以便在门户中管理 SQL Server VM, 并使用自动修补和自动备份等功能。You must then register your SQL Server VM with the SQL Server VM resource provider to manage your SQL Server VM in the portal, as well as utilize features such as automated patching and automatic backups.

创建Creation

  1. 如何创建装有 SQL Server 的 Azure 虚拟机?How do I create an Azure virtual machine with SQL Server?

    最简单的方法是创建包含 SQL Server 的虚拟机。The easiest method is to create a Virtual Machine that includes SQL Server. 有关注册 Azure 并从门户创建 SQL Server VM 的教程, 请参阅Azure 门户中的预配 SQL Server 虚拟机For a tutorial on signing up for Azure and creating a SQL Server VM from the portal, see Provision a SQL Server virtual machine in the Azure portal. 可选择使用按秒付费 SQL Server 许可的虚拟机映像,或者可以使用允许自带 SQL Server 许可证的映像。You can select a virtual machine image that uses pay-per-second SQL Server licensing, or you can use an image that allows you to bring your own SQL Server license. 此外,你也可以选用免费许可版(开发人员版或速成版),或通过重新使用本地许可证在 VM 上手动安装 SQL Server。You also have the option of manually installing SQL Server on a VM with either a freely licensed edition (Developer or Express) or by reusing an on-premises license. 请确保向SQL Server VM 资源提供程序注册你的 SQL Server VM , 以便在门户中管理 SQL Server VM, 并使用自动修补和自动备份等功能。Be sure to register your SQL Server VM with the SQL Server VM resource provider to manage your SQL Server VM in the portal, as well as utilize features such as automated patching and automatic backups. 如果自带许可,必须在 Azure 上通过软件保障实现许可证移动性If you bring your own license, you must have License Mobility through Software Assurance on Azure. 有关详细信息,请参阅 SQL Server Azure VM 定价指南For more information, see Pricing guidance for SQL Server Azure VMs.

  2. 如何将本地 SQL Server 数据库迁移到云中?How can I migrate my on-premises SQL Server database to the Cloud?

    首先,请创建装有 SQL Server 实例的 Azure 虚拟机。First create an Azure virtual machine with a SQL Server instance. 然后将本地数据库迁转到该实例。Then migrate your on-premises databases to that instance. 有关数据迁移策略,请参阅将 SQL Server 数据库迁移到 Azure VM 中的 SQL ServerFor data migration strategies, see Migrate a SQL Server database to SQL Server in an Azure VM.

授权Licensing

  1. 如何在 Azure VM 上安装 SQL Server 的许可版本?How can I install my licensed copy of SQL Server on an Azure VM?

    有三种方法可以实现此目的。There are three ways to do this. 如果你是企业协议 (EA) 客户, 则可以预配支持许可证的虚拟机映像之一, 这也称为 "自带许可证" (BYOL)。If you're an enterprise agreement (EA) customer, you can provision one of the virtual machine images that supports licenses, which is also known as bring-your-own-license (BYOL). 如果你有软件保障, 可以在现有的即用即付 (PAYG) 映像上启用Azure 混合权益If you have software assurance, you can enable the Azure Hybrid Benefit on an existing pay-as-you-go (PAYG) image. 或者, 你可以将 SQL Server 安装媒体复制到 Windows Server VM, 然后在 VM 上安装 SQL Server。Or you can copy the SQL Server installation media to a Windows Server VM, and then install SQL Server on the VM. 请确保向资源提供程序注册你的 SQL Server VM, 以获取门户管理、自动备份和自动修补等功能。Be sure to register your SQL Server VM with the resource provider for features such as portal management, automated backup and automated patching.

  2. 如果 SQL Server 仅用于待机/故障转移,是否必须付费才能在 Azure VM 上为 SQL Server 授予许可?Do I have to pay to license SQL Server on an Azure VM if it is only being used for standby/failover?

    若要为备用次要可用性组或故障转移群集实例提供免费的被动许可证, 必须满足以下所有条件, 如许可指南 PDF所述:To have a free passive license for a standby secondary availability group or failover clustered instance, you must meet all of the following criteria as outlined by the licensing guide PDF:

    1. 你有通过软件保障获得的许可移动性You have license mobility through software assurance.
    2. 被动 SQL Server 实例不会向客户端提供 SQL Server 数据或运行活动 SQL Server 工作负荷。The passive SQL Server instance does not serve SQL Server data to clients or run active SQL Server workloads. 它仅用于与主服务器同步, 否则, 维护被动数据库处于热备用状态。It is only used to synchronize with the primary server and otherwise maintain the passive database in a warm standby state. 如果它正在为数据提供服务 (例如向运行活动 SQL Server 工作负荷的客户端报告, 或执行任何 "工作", 如辅助服务器的其他备份), 则必须是付费许可 SQL Server 实例。If it is serving data, such as reports to clients running active SQL Server workloads, or performing any "work", such as additional backups from the secondary server, then it must be a paid licensed SQL Server instance.
    3. Active SQL Server 许可证由软件保障涵盖, 并允许使用一个被动辅助 SQL Server 实例, 最多可有与许可的活动服务器相同的计算量。The active SQL Server license is covered by Software Assurance and allows for one passive secondary SQL Server instance, with up to the same amount of compute as the licensed active server, only.
    4. 辅助 SQL Server VM 利用自带许可证 (BYOL) 或 Azure 混合权益 (AHB)许可证模型The secondary SQL Server VM utilizes the bring-your-own-license (BYOL) or Azure Hybrid Benefit (AHB) license model.
  3. 如果已通过即用即付库映像之一创建了 VM,是否可以将该 VM 更改为使用自己的 SQL Server 许可证?Can I change a VM to use my own SQL Server license if it was created from one of the pay-as-you-go gallery images?

    是的。Yes. 可以通过启用Azure 混合权益轻松地将即用即付 (PAYG) 库图像切换为自带许可证 (BYOL)。You can easily switch a pay-as-you-go (PAYG) gallery image to bring-your-own-license (BYOL) by enabling the Azure Hybrid Benefit. 有关详细信息,请参阅如何更改 SQL Server VM 的许可模型For more information, see How to change the licensing model for a SQL Server VM. 目前,此功能仅面向公有云客户提供。Currently, this facility is available only for Public Cloud customers.

  4. 切换许可模型是否需要将 SQL Server 停机?Will switching licensing models require any downtime for SQL Server?

    否。No. 更改许可模型不需将 SQL Server 停机,因为更改会立即生效,不需重启 VM。Changing the licensing model does not require any downtime for SQL Server as the change is effective immediately and does not require a restart of the VM. 但是, 若要向 SQL Server VM 资源提供程序注册你的 SQL Server VM, 则Sql iaas 扩展为必备组件, 并且在_完整_模式下安装 sql iaas 扩展会重启 SQL Server 服务。However, to register your SQL Server VM with the SQL Server VM resource provider, the SQL IaaS extension is a prerequisite and installing the SQL IaaS extension in full mode restarts the SQL Server service. 同样, 如果需要安装 SQL IaaS 扩展, 则可以在_轻型_模式下安装它以实现有限的功能, 或在维护时段内以_完全_模式安装。As such, if the SQL IaaS extension needs to be installed, either install it in lightweight mode for limited functionality, or install it in full mode during a maintenance window. 在_轻型_模式下安装的 SQL IaaS 扩展可随时升级到_完整_模式, 但需要重新启动 SQL Server 服务。The SQL IaaS extension installed in lightweight mode can be upgraded to full mode at any time, but requires a restart of the SQL Server service.

  5. 是否可以使用 Azure 门户来管理同一 VM 上的多个实例?Can I use the Azure portal to manage multiple instances on the same VM?

    否。No. 门户管理是 SQL Server VM 资源提供程序提供的一项功能, 它依赖于 SQL Server IaaS 代理扩展。Portal management is a feature provided by the SQL Server VM resource provider, which relies on the SQL Server IaaS Agent extension. 同样, 对资源提供程序的限制同样适用于扩展。As such, the same limitations apply to the resource provider as to the extension. 只要正确配置, 门户就只能管理一个默认实例或一个命名实例。The portal can either only manage one default instance, or one named instance, as long as it was configured correctly. 有关这些限制的详细信息, 请参阅SQL Server IaaS 代理扩展For more information on these limitations, see SQL Server IaaS agent extension.

  6. CSP 订阅是否能够激活 Azure 混合权益?Can CSP subscriptions activate the Azure Hybrid Benefit?

    能,Azure 混合权益适用于 CSP 订阅。Yes, the Azure Hybrid Benefit is available for CSP subscriptions. CSP 客户应首先部署即用即付映像,然后将许可模式更改为自带许可。CSP customers should first deploy a pay-as-you-go image, and then change the licensing model to bring-your-own-license.

  7. 是否会向新的 SQL Server VM 资源提供程序注册我的 VM 带来额外的费用?Will registering my VM with the new SQL Server VM resource provider bring additional costs?

    否。No. SQL Server VM 的资源提供程序只为 Azure VM 上的 SQL Server 启用了额外的可管理性, 无需支付额外费用。The SQL Server VM resource provider just enables additional manageability for SQL Server on Azure VM with no additional charges.

  8. SQL Server VM 的资源提供程序是否适用于所有客户?Is the SQL Server VM resource provider available for all customers?

    可以, 但前提是使用资源管理器模型将 SQL Server VM 部署到公有云, 而不是经典模型。Yes, as long as the SQL Server VM was deployed on the public cloud using the Resource Manager model, and not the classic model. 所有其他客户都可以注册新的 SQL Server VM 资源提供程序。All other customers are able to register with the new SQL Server VM resource provider. 但是, 只有具有软件保障权益的客户才能通过激活 SQL Server VM 上的Azure 混合权益 (AHB)来使用自己的许可证。However, only customers with the Software Assurance benefit can use their own license by activating the Azure Hybrid Benefit (AHB) on a SQL Server VM.

  9. 如果移动或删除 VM 资源, 资源提供程序 (SqlVirtualMachine) 资源会发生什么情况?What happens to the resource provider (Microsoft.SqlVirtualMachine) resource if the VM resource is moved or dropped?

    删除或移动 Microsoft.Compute/VirtualMachine 资源时,会通知关联的 Microsoft.SqlVirtualMachine 资源以异步方式复制此操作。When the Microsoft.Compute/VirtualMachine resource is dropped or moved, then the associated Microsoft.SqlVirtualMachine resource is notified to asynchronously replicate the operation.

  10. 如果删除资源提供程序 (SqlVirtualMachine) 资源, VM 会发生什么情况?What happens to the VM if the resource provider (Microsoft.SqlVirtualMachine) resource is dropped?

    删除 Microsoft.SqlVirtualMachine 资源时,Microsoft.Compute/VirtualMachine 资源不受影响。The Microsoft.Compute/VirtualMachine resource is not impacted when the Microsoft.SqlVirtualMachine resource is dropped. 但是,许可更改会默认回退到原始的映像源。However, the licensing changes will default back to the original image source.

  11. 是否可以向 SQL Server VM 资源提供程序注册自行部署 SQL Server Vm?Is it possible to register self-deployed SQL Server VMs with the SQL Server VM resource provider?

    是的。Yes. 如果从自己的媒体部署 SQL Server,并安装 SQL IaaS 扩展,则可将 SQL Server VM 注册到资源提供程序,以便获取 SQL IaaS 扩展提供的可管理性权益。If you deployed SQL Server from your own media, and installed the SQL IaaS extension you can register your SQL Server VM with the resource provider to get the manageability benefits provided by the SQL IaaS extension. 但是, 无法将自部署 SQL Server VM 转换为即用即付。However, you are unable to convert a self-deployed SQL Server VM to pay-as-you-go.

  12. 是否可以在使用经典模型部署的 SQL Server VM 上切换许可模型?Is it possible to switch licensing model on a SQL Server VM deployed using classic model?

    否。No. 在经典 VM 上不支持更改许可模式。Changing licensing model is not supported on a classic VM. 可以将 VM 迁移到 Azure 资源管理器型号, 并向 SQL Server VM 资源提供程序进行注册。You may migrate your VM to the Azure Resource Manager model and register with the SQL Server VM resource provider. 将 VM 注册到 SQL Server VM 资源提供程序后, 会在 VM 上提供授权模型更改。Once the VM is registered with the SQL Server VM resource provider, licensing model changes will be available on the VM.

管理Administration

  1. 是否可以在同一 VM 上安装另一个 SQL Server 实例?是否可以更改默认实例的已安装功能?Can I install a second instance of SQL Server on the same VM? Can I change installed features of the default instance?

    可以。Yes. SQL Server 安装媒体位于 C 驱动器上的某个文件夹中。The SQL Server installation media is located in a folder on the C drive. 可从该位置运行 Setup.exe 添加新的 SQL Server 实例,或更改计算机上 SQL Server 的其他已安装功能。Run Setup.exe from that location to add new SQL Server instances or to change other installed features of SQL Server on the machine. 请注意,某些功能(例如自动备份、自动修补和 Azure Key Vault 集成)仅对默认实例或者正确配置的命名实例起作用(请参阅“问题 3”)。Note that some features, such as Automated Backup, Automated Patching, and Azure Key Vault Integration, only operate against the default instance, or a named instance that was configured properly (See Question 3).

  2. 是否可以卸载 SQL Server 的默认实例?Can I uninstall the default instance of SQL Server?

    可以,但需注意以下事项。Yes, but there are some considerations. 首先, 根据 VM 的许可证型号, SQL Server 关联的计费可能会持续发生。First, SQL Server-associated billing may continue to occur depending on the license model for the VM. 其次, 如前面的答案中所述, 有一些功能依赖于SQL Server IaaS 代理扩展Second, as stated in the previous answer, there are features that rely on the SQL Server IaaS Agent Extension. 如果卸载默认实例时未删除 IaaS 扩展, 该扩展将继续查找默认实例并可能生成事件日志错误。If you uninstall the default instance without removing the IaaS extension also, the extension continues to look for the default instance and may generate event log errors. 这些错误来自以下两个源:Microsoft SQL Server 凭据管理和 Microsoft SQL Server IaaS 代理。These errors are from the following two sources: Microsoft SQL Server Credential Management and Microsoft SQL Server IaaS Agent. 其中一个错误可能类似于以下内容:One of the errors might be similar to the following:

    建立与 SQL Server 的连接时,出现网络相关或特定于实例的错误。A network-related or instance-specific error occurred while establishing a connection to SQL Server. 找不到或无法访问服务器。The server was not found or was not accessible.

    如果你决定卸载默认实例,还要卸载 SQL Server IaaS 代理扩展If you do decide to uninstall the default instance, also uninstall the SQL Server IaaS Agent Extension as well.

  3. 是否可将 SQL Server 的命名实例与 IaaS 扩展配合使用Can I use a named instance of SQL Server with the IaaS extension?

    如果该命名实例是 SQL Server 上的唯一实例,并且正确卸载了原始的默认实例,则可以这样做。Yes, if the named instance is the only instance on the SQL Server, and if the original default instance was uninstalled properly. 如果没有默认实例, 且单个 SQL Server VM 上有多个命名实例, 则 SQL Server IaaS 代理扩展将无法安装。If there is no default instance and there are multiple named instances on a single SQL Server VM, the SQL Server IaaS agent extension will fail to install.

  4. 能否完全从 SQL Server VM 中删除 SQL Server?Can I remove SQL Server completely from a SQL Server VM?

    是的, 但将继续按SQL Server Azure vm 的定价指南中所述为 SQL Server VM 付费。Yes, but you will continue to be charged for your SQL Server VM as described in Pricing guidance for SQL Server Azure VMs. 如果不再需要 SQL Server,可以部署新的虚拟机并将数据和应用程序迁移到新的虚拟机。If you no longer need SQL Server, you can deploy a new virtual machine and migrate the data and applications to the new virtual machine. 然后可以删除 SQL Server 虚拟机。Then you can remove the SQL Server virtual machine.

更新和修补Updating and Patching

  1. 如何将 Azure VM 中的 SQL Server 更改为另一版本?How do I change to a different version/edition of the SQL Server in an Azure VM?

    客户可以使用包含所需 SQL Server 版本的安装介质来更改其 SQL Server 版本。Customers can change their version/edition of SQL Server by using setup media that contains their desired version or edition of SQL Server. 更改版本以后,使用 Azure 门户修改 VM 的版本属性,使之准确反映 VM 的计费。Once the edition has been changed, use the Azure portal to modify the edition property of the VM to accurately reflect billing for the VM. 有关详细信息, 请参阅更改版本的 SQL Server VMFor more information, see change edition of a SQL Server VM. 不同版本的 SQL Server 没有计费差异, 因此, 在更改 SQL Server 版本后, 无需执行其他操作。There is no billing difference for different versions of SQL Server, so once the version of SQL Server has been changed, no further action is needed.

  2. 在哪里可以获取安装媒体来更改 SQL Server 的版本?Where can I get the setup media to change the edition or version of SQL Server?

具有软件保障的客户可以从批量许可中心获得其安装媒体。Customers who have software assurance can obtain their installation media from the Volume Licensing Center. 没有软件保障的客户可以使用具有所需版本的 marketplace SQL Server VM 映像中的设置媒体。Customers that do not have software assurance can use the setup media from a marketplace SQL Server VM image that has their desired edition.

  1. 如何将更新和服务包应用到 SQL Server VM?How are updates and service packs applied on a SQL Server VM?

    虚拟机允许控制主机,包括应用更新的时间与方法。Virtual machines give you control over the host machine, including when and how you apply updates. 对于操作系统,可以手动应用 Windows 更新,或者启用名为自动修补的计划服务。For the operating system, you can manually apply windows updates, or you can enable a scheduling service called Automated Patching. 自动修补将安装任何标记为重要的更新,包括该类别中的 SQL Server 更新。Automated Patching installs any updates that are marked important, including SQL Server updates in that category. 必须手动安装其他可选的 SQL Server 更新。Other optional updates to SQL Server must be installed manually.

  2. 向 SQL Server VM 资源提供程序注册后, 能否升级 SQL Server 2008/2008 R2 实例?Can I upgrade my SQL Server 2008 / 2008 R2 instance after registering it with the SQL Server VM resource provider?

    是的。Yes. 你可以使用任何安装媒体来升级 SQL Server 的版本和版本, 然后将SQL IaaS 扩展模式从_无代理_升级到_完整_版本。You can use any setup media to upgrade the version and edition of SQL Server, and then you can upgrade your SQL IaaS extension mode from no agent to full. 这样做将使你能够访问 SQL IaaS 扩展的所有优点, 例如门户可管理性、自动备份和自动修补。Doing so will give you access to all the benefits of the SQL IaaS extension such as portal manageability, automated backups, and automated patching.

常规General

  1. Azure VM 是否支持 SQL Server 故障转移群集实例 (FCI)?Are SQL Server Failover Cluster Instances (FCI) supported on Azure VMs?

    是的。Yes. 可在 Windows Server 2016 上创建 Windows 故障转移群集 ,并将存储空间直通 (S2D) 用于群集存储。You can create a Windows Failover Cluster on Windows Server 2016 and use Storage Spaces Direct (S2D) for the cluster storage. 或者,可使用第三方群集或存储解决方案,如 Azure 虚拟机中 SQL Server 的高可用性和灾难恢复中所述。Alternatively, you can use third-party clustering or storage solutions as described in High availability and disaster recovery for SQL Server in Azure Virtual Machines.

    重要

    目前, Azure 上的 SQL Server FCI 不支持_完整_ SQL Server IaaS 代理扩展At this time, the full SQL Server IaaS Agent Extension is not supported for SQL Server FCI on Azure. 建议从参与 FCI 的 Vm 中卸载_完全_扩展, 并改为在_轻型_模式下安装扩展。We recommend that you uninstall the full extension from VMs that participate in the FCI, and install the extension in lightweight mode instead. 此扩展插件支持功能, 如自动备份和修补功能, 以及 SQL Server 的一些门户功能。This extension supports features, such as Automated Backup and Patching and some portal features for SQL Server. 卸载_完整_代理后, 这些功能对 SQL Server 的 vm 将不起作用。These features will not work for SQL Server VMs after the full agent is uninstalled.

  2. SQL Server Vm 与 SQL 数据库服务之间的区别是什么?What is the difference between SQL Server VMs and the SQL Database service?

    从概念上讲,在 Azure 虚拟机上运行 SQL Server 与在远程数据中心运行 SQL Server 并没什么不同。Conceptually, running SQL Server on an Azure virtual machine is not that different from running SQL Server in a remote datacenter. 相比之下, SQL 数据库 可提供数据库即服务。In contrast, SQL Database offers database-as-a-service. 使用 SQL 数据库时,无法访问托管数据库的计算机。With SQL Database, you do not have access to the machines that host your databases. 有关完整比较,请参阅选择云 SQL Server 选项:Azure SQL (PaaS) 数据库或 Azure VM 上的 SQL Server (IaaS)For a full comparison, see Choose a cloud SQL Server option: Azure SQL (PaaS) Database or SQL Server on Azure VMs (IaaS).

  3. 如何在 Azure VM 上安装 SQL 数据工具?How do I install SQL Data tools on my Azure VM?

    Microsoft SQL Server 数据工具 - Visual Studio 2013 商业智能下载并安装 SQL 数据工具。Download and install the SQL Data tools from Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013.

  4. SQL Server Vm 上是否支持 MSDTC 的分布式事务?Are distributed transactions with MSDTC supported on SQL Server VMs?

    是的。Yes. SQL Server 2016 SP2 及更高版本支持本地 DTC。Local DTC is supported for SQL Server 2016 SP2 and greater. 但是, 在使用 Always On 可用性组时, 必须对应用程序进行测试, 因为故障转移过程中正在进行的事务将失败, 并且必须重试。However, applications must be tested when utilizing Always On availability groups, as transactions in-flight during a failover will fail and must be retried. 群集 DTC 从 Windows Server 2019 开始使用。Clustered DTC is available starting with Windows Server 2019.

资源Resources

Windows VMWindows VMs:

Linux VMLinux VMs: