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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DBCC CheckDB

Author  Topic 

vicki
Posting Yak Master

117 Posts

Posted - 2002-04-22 : 10:24:21
When I run dbcc checkdb for one DB I have the error return with
1) Table error: Allocation page (1:242640) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.

Server: Msg 8921, Level 16, State 1, Line 1
2) CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

3) Table error: Extent (1:249600) object ID 1, index ID 2 is beyond the range of this database.

4) CHECKDB found 10189 allocation errors and 1 consistency errors in database 'Company'.


what these error mean? and what do I need to to do now?, please help

thanks


AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-04-22 : 20:51:18
Pickup the conversation here: [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=15138[/url]

Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-04-22 : 20:52:41
Vicki

Please don't cross post! We all read all the forums, you only need to post it once.

Damian
Go to Top of Page
   

- Advertisement -