I have database of size 5TB. There is a File group (FG1) created and in it, there are two files (F1 and F2) used for user tables (When tables are created they use the files to load the data).
Now, I want to create F3 and migrate all the data from F2 to F3. My question is what is the best way to do it?
So far I tried Shrinkfile with EmptyFile argument and that took way longer as the data to be moved is huge.
Please suggest a better, efficient way to do this.