|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Wednesday, May 16, 2012 7:50 AM
Points: 16,
Visits: 104
|
|
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..
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 904,
Visits: 4,398
|
|
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?
|
|
|
|
