|
DBA007
Posting Yak Master
India
141 Posts |
 Posted - 07/22/2010 : 05:27:24
|
The disk has 15gb of free space available but the dbintegrity fails because of below error,i have tried shrinking and restarting sqlservices,but no use
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'dbo.SORT temporary run storage: 140737525776384' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
|
|
|
webfred
Flowing Fount of Yak Knowledge
Germany
8514 Posts |
Posted - 07/22/2010 : 05:47:06
|
Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
I think it is still the same as here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=147171
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
tempdb
