0

Can I rebuild clustered index ONLINE (MS SQL 2017 Developer Edition) for specific partition which is on partitioned table with different filegroups? Selected partition is on read_write filegroup, but there's read_only filegroup too.

When I try:

ALTER INDEX PK_INDEXNAME ON TABLE_NAME REBUILD PARTITION=6 WITH (ONLINE=ON)

it gives me error:

Msg 1924, Level 16, State 2, Line 35
Filegroup 'SECONDARY' is read-only.

I can rebuild index without any problems offline. I've found Microsoft Fix/Resolution page about the same problem on SQL 2014. But they fixed it on CU1.

  • Bugs are known to come back from time to time between versions. Open a support ticket or submit a bug report via aka.ms/sqlfeedback – John Eisbrener Oct 23 '19 at 14:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.