Optimization Job failure

  • Hi All,

    It will be highly appreciated , if anyone can help me out of this issue.

    Job failed with the Error 1105: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object '(SYSTEM table id: -314978603)' in database because the 'PRIMARY' file group is full.

    Even though there is enogh space in drive about 27GB, i am sure why this alert is triggered. the job does rebuild indexing. The datafile size is 224GB (restricted) and space available is 28GB . The auto growth option is also enabled for this DB.

    Please suggest me how to resolve this issue.

    Thanks in advance,

    KK

  • Your data file is restricted - what is the max size allowed? What is the auto-growth increment? How large is the transaction log (goes to determine how much actual space is available in the data file).

    And finally, your database is 224GB and you are allowing autogrow? That is going to be an extremely invasive operation that you have no control over when it happens. I would highly recommend that you plan for growth by monitoring data space usage and leaving at least 20% space available in the data file at all times.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Also, just add space to your data file. indexing consumes space and you might be too low for it to run if you don't have autogrow enabled.

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

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