Hi,@Kman
Welcome to Microsoft T-SQL Q&A Forum!
Have you tried to use auxiliary file groups? The general process is as follows:
- Create auxiliary file groups.
- Add the data files to the auxiliary file group.
- Move the table to the secondary filegroup by moving the clustered index with the primary key constraint.
- Move the table to the secondary filegroup by moving the clustered index without the primary key.
But you need to pay attention to a problem . If there are empty files in the file group , if you directly migrate the data to other files , there will be some files that cannot be emptied . Although the MS document mentioned that it has no effect , I believe it's only a matter of time before encountering this kind of problem.
Please refer to this document.
Best regards,
Bert Zhou
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.