AzureSQL icon indicating copy to clipboard operation
AzureSQL copied to clipboard

Operation cannot be performed resumably on a table with a Clustered Columnstore Index

Open MaxNulls opened this issue 2 years ago • 0 comments

Procedure fails when it tries to do rebuild on Clustered Column Store Index:

ALTER INDEX [TableName] REBUILD WITH(ONLINE=ON,MAXDOP=1, RESUMABLE=ON);

Error: Msg 35397, Level 16, State 1, Line 1 alter statement failed because the operation cannot be performed resumably on a table with a columnstore index. Perform the operation without specifying the RESUMABLE option or drop (or disable) the columnstore index before performing the operation using the RESUMABLE option.

MaxNulls avatar Nov 21 '22 17:11 MaxNulls