Post reply

Rebulid Index is failing with error

  • November 8, 2010 at 7:03 am

    #231092

    Rebulid Index is failing with below error how to tackle this?

    Executing the query "ALTER INDEX [wysdm_logging_idx1] ON [dbo].[wysdm_logging] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF )

    " failed with the following error: "Could not allocate a new page for database 'D_DATAMINE' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Thanks in advance!

  • November 8, 2010 at 7:06 am

    #1247646

    it says you are out of space, give the data file more space..

  • November 8, 2010 at 7:21 am

    #1247653

    Did you read the error?

    Sqlsavy (11/8/2010)

    "Could not allocate a new page for database 'D_DATAMINE' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 8, 2010 at 7:39 am

    #1247658

    yes I did and there is enough space on the drive...

    is there anyway I can calucate the space required for the reindex?

  • November 8, 2010 at 7:44 am

    #1247661

    Free space = total size of the index, at least. Check that the file's autogrow doesn't have a set limit.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 8, 2010 at 8:37 am

    #1247694

    Thanks I have done that now will wait and see if job will be successful over the weekend

Viewing 6 posts - 1 through 5 (of 5 total)

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