I am having issues when creating two ndf files (in addition to the mdf that sits in the primary filegroup). I have created these two seconday data files and assigned them to their own filegroup and set this filegroup as the default.
I have followed the rules of proportional fill (well, what I understand them to be!) to ensure that the physical size of the ndf's are the same and that they have the same amount of free space in the two files before I create an object in the user filegroup and populate it. However, on populating the table only one of the ndf files gets populated and grows whilst the second one remains untouched.
I was expecting the data to be split evenly between these two files and for their sizes to be identical?
I am running this on SQL Server 2008 STD x64 SP2
Any help or advice on this matter would be greatly appreciated