Post reply

error while creating index

  • April 9, 2006 at 10:56 pm

    #89916

    I am getting this sort of an error while creating an index. What could be the possible reason?

    Unable to create index 'index_name'. 

    ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate new page for database 'database_name'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth.

    [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

  • April 9, 2006 at 11:48 pm

    #631656

    Harnessh

     

    It sounds like you have no more room to gorw in the data file. Now this is either because you have set the max size of the file and have reached it or the drive is full. Have a look at the prpoties of the database and look at the primry file group, it is probably set to a max size. Change that to unlimited.

    If how ever that is not the case and it is the drive that is full, and can over come this problem by adding another datfile to the file group and placing it on a new drive.

     

    Good luck.

     

     

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

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

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