question

Wilfred van Dijk avatar image
Wilfred van Dijk asked

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?
filegroupstoragespace
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
KenJ avatar image
KenJ answered
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][1] 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. [1]: http://msdn.microsoft.com/en-us/library/ms187087.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.