我们在带有磁盘的SQL Availability Group服务器上拥有数据库.我们可以缩小此服务器上直接连接磁盘的大小吗? [英] We have data bases on a SQL Availability Group server with an attached disk. Can we shrink the size of the direct attached disk on this server?

问题描述

我们在带有磁盘的SQL Availability Group服务器上拥有数据库.  这是在Azure环境中.

We have data bases on a SQL Availability Group server with an attached disk.   This is in the Azure envronment.

我们可以在不影响数据的情况下缩小此服务器上直接连接存储的大小吗?

Can we shrink the size of the direct attached storage on this server without impacting the data? 

我们将调整附加磁盘的大小，并为数据库留出足够的空间.

We will be resizing the size of the attached disk with enough space for the databases.

此大小调整是否影响其他副本(我们在此SQL AG组中有第二个节点)?

Does this resizing impact the other replicas ( we have a 2nd node in this SQL AG group )?

我们还将调整包含副本的磁盘的大小.

We would also be resizing the disk which contains the replica.

dsk

推荐答案

Hello,

缩小托管磁盘根据以下文档不支持:

Shrinking a managed disk is not supported based on the following document:

https://docs.microsoft.com/zh-cn/azure/virtual-machines/windows/faq-for-disks

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/faq-for-disks

希望这会有所帮助.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于我们在带有磁盘的SQL Availability Group服务器上拥有数据库.我们可以缩小此服务器上直接连接磁盘的大小吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！