could not allocate space but 2nd file has enough space
Hi, I have this situation: - datafile 1, primary filegroup, autogrowth off (because disk is almost full) - datafile2, primary filegroup, autogrowth on, enough space (on another disk) During index maintenance, I got the error "could not allocate space (...) because PRIMARY filegroup is full" I don't get it: why is is table not extending on the 2nd datafile?
The Proportional Fill algorithm will do *most* of the file allocations from the smaller file, but you cannot force *all* of the allocations to come from the smaller file, so it needed to autogrow when it was time to take more space. Further reading here: [
http://msdn.microsoft.com/en-us/library/ms187087.aspx] Can you move both files onto the disk that has more room? If you want all of your objects spread evenly between two files, you can create a second filegroup with two files and move the objects from your original filegroup into the new one. The files will then be more balanced. :