Post reply

TEMPDB' because the 'DEFAULT' filegroup is full

  • December 21, 2011 at 8:51 am

    #148933

    I have one DTS configured in prod failing suddenly with below error msg:

    Could not allocate space for object '(SYSTEM table id: -210087109)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.

    ---------

    I have done below activities till now but no luck:

    1.Failover the cluster server

    2.Drive has enough space.

    3.Created ndf file in different drive

    Pls advise..

  • January 11, 2012 at 1:05 am

    #1431604

    I know that this post is few weeks older, still responding....

    1) Failover the cluster server. This doesn't help becuase same file is used by the nodes.

    2) Drive has enough space. But is auto growth ON?

    3) Created ndf file in different drive. But did you create it for the filegroup in question?

    Are you sure it is 'DEFAULT' filegroup of 'TEMPDB'? Becuase TEMPDB has only one filegroup called 'PRIMARY'. You cannot add additional filegroup called 'DEFAULT' to TEMPDB. So how did you get that error message?

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

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