无法恢复重建禁用索引 [英] cannot resume rebuilding disabled index

问题描述

b

我已在我的Azure SQL服务器数据库上禁用了索引，然后开始使用  可恢复=上 选项。
在我打破重建之后，我无法恢复或中止它，因为索引被禁用并且我收到错误：

Hi,

I have disabled an index on my Azure SQL server database and then started rebuilding it with resumable=on option. After I broke the rebuild I cannot resume or abort it because index is disabled and I get an error:

无法对禁用的索引执行指定的操作

Cannot perform the specified operation on disabled index

最糟糕的是我无法删除此索引或创建任何其他索引，因为我收到另一个错误：

The worst thing is that I can't drop this index or create any other indexes as I get another error:

无法对ID为1918629878的'object'执行此操作，因为一个或多个索引当前处于可恢复索引重建状态。有关详细信息，请参阅sys.index_resumable_operations。

Cannot perform this operation on 'object' with ID 1918629878 as one or more indexes are currently in resumable index rebuild state. Please refer to sys.index_resumable_operations for more details.

如何解决此问题？

谢谢

How can I resolve this?
Thanks

推荐答案

I认为这是限制之一，你不能在禁用的索引上使用它（resumable = on）。 

I think this is one of the restrictions, you cannot user it (resumable =on) on disabled indexes. 

BTW，你看到运行这个选择

BTW, what you see running this select

SELECT * FROM sys.index_resumable_operations

SELECT * FROM sys.index_resumable_operations

这篇关于无法恢复重建禁用索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！