Scneario: We had only 1 data file(.mdf) which is now around 900 GB. We are planning to split it across multiple drives to improve IO performance.
As of now we have created 8 different data files in 8 drives within PRIMARY Filegroup.
what is the most efficient of moving data from 1 data file(.mdf) to another within same filegroup i.e PRIMARY Filegroup.
If that is not possible, then what is the best way of splitting the data across multiple drives in the same database?
We tried using DBCC SHRINKFILE with EMPTYFILE but it throws errors as it cannot move system files from .mdf file.