Split a file group into multiple data files

(Trayce Jordan) Periodically we are asked how to split an existing filegroup into multiple data files. The quick answer is that SQL Server does not have a built-in way for you to do that automatically, but you can do it yourself.

Read More - Register for Free Membership