posted on Friday, May 14, 2004 5:00 PM
by
Enigma
Page Allocation Error - SQL Server
Harshal, a friend of mine just had an error where he was not able to increase the size of database and the server gave an error .
Could not allocate new page for database 'rough'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth
Error 5149: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file
The disk had ample free space but it seemed like SQL Server was not able to see it. While troubleshooting this, the magic figure of 4095 MB (232 bytes minus 1 byte)pointed me to the solution from long ago from the days of FAT16 and FAT32 filesystems.
The solution for the benefit of anybody who might encounter such a problem is :
FAT32 does not support files greater than 4 GB.
So convert your disk to NTFS, if you need files greater than 4 GB.
PS : I am still waiting for a confirmation of the solution ... but I am willing to bet on this solution ...