Post reply

Could not allocate new page for database

  • April 8, 2005 at 1:26 am

    #163222

    Today when I checked the event viewer I got the following error.

    Could not allocate new page for database 'cct'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth

    I want to know the possible causes of this error and ways to fix this ..so that this situation should not come ever.Pls guide

    I have a NTFS file system

  • April 8, 2005 at 3:09 am

    #551401

    I've remember seeing this in SQL 7 from time to time, basically it's telling you that it thinks the default filegroup is full (the data file).  This sometimes happened (albeit rarely) regardless of whether the MDF file was set to autogrow or not, othertimes is expanded correctly as needed.

    To stop it from happening you can manually expand the size of the MDF file and start monitoring it on a weekly basis (or write something to automatically notify you when space drops below a certain point (PM me if you want a copy of mine)).

    I've learnt from this and now try to allocate enough empty database space for the next 6 months worth of growth, which helps cut down on file fragmentation too

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply