• coreyjbaum (9/28/2016)


    I have a single data file thats over 5tb in size and id like to split it up into multiple files across multiple drives. Whats the best way to go about doing this making sure that the single file is evenly distributed across the new files.

    I have spent some time googling it and i just cant seem to come up with the right keywords.

    Thanks

    You can just google on: proportional fill

    That should give you the results you were looking for. You can refer to this article on SCC that give more info on how it works.

    http://www.sqlservercentral.com/blogs/mr-fox-sql/2016/02/24/sql-filegroupfile-proportional-fill-algorithm/

    Sue