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-13 : 05:35:50
|
| Dbcc checkdb failed on one db with below error.Msg 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: 140755948077056' 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-13 : 05:47:21
|
And what is your question?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-13 : 07:04:37
|
| Increase the size of tempDB, run the CheckDB again. It's failed because, as it stated, TempDB is out of space.--Gail ShawSQL Server MVP |
|
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2010-07-14 : 12:26:47
|
| there was 5gbfree space available, even then the integrity job fails stating of the same error,I have done the shrinking of the templog and truncated the log,but of 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: 140737544978432' 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. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-15 : 01:30:55
|
| Why are you shrinking? TempDB needs to grow, not be made smaller.The error is clear, TempDB is running out of space. Check that there's enough free space on the drive (5GB is apparently not enough) and that there's no limit on the size of the files.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
CHECKDB ERROR