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.