| Author |
 Topic  |
|
|
DBA007
Posting Yak Master
India
141 Posts |
 Posted - 07/13/2010 : 05:35:50
|
Dbcc checkdb failed on one db with below error.
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: 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
Flowing Fount of Yak Knowledge
Germany
8515 Posts |
Posted - 07/13/2010 : 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
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 07/13/2010 : 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 Shaw
SQL Server MVP |
|
|
|
DBA007
Posting Yak Master
India
141 Posts |
Posted - 07/14/2010 : 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 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: 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
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 07/15/2010 : 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 Shaw
SQL Server MVP |
|
|
| |
Topic |
|
|
|
CHECKDB ERROR
