Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2010-07-22 : 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 useMsg 8921, Level 16, State 1, Line 1Check 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 1Could 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
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-22 : 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 herehttp://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. |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-07-22 : 05:55:56
|
| I did all those which you have specified but of no use. |
|
|
|
|
|
|
|
|
tempdb