I need urgent help on DBCC errors.

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 2005 Forums

SQL Server Administration (2005)

I need urgent help on DBCC errors.

Author

Topic

NguyenL71
Posting Yak Master

228 Posts

Posted - 2008-10-09 : 16:51:28

Hi,

I am getting the errors below after running DBCC check db. I need to find down what table(s) having problems and probably fix individual table.
Does anyone has some suggestions or documents how to fix this. Please don't suggest RESTORE from the latest backup file(s). We already done that and the
previous backup files having the same problems. Any helps would greatly appreciate.

DBCC CHECKDB (ProductionDB) WITH ALL_ERRORMSGS
go

-- Need to find down which table(s) having problems.

Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (7:3154320). The PageId in the page header = (0:0).

Server: Msg 8998, Level 16, State 1, Line 1

Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 91 pages from (7:3154320) to (7:3162407). See other errors for cause.

Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (7:3162408). The PageId in the page header = (0:0).

Server: Msg 8998, Level 16, State 1, Line 1

Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 91 pages from (7:3162408) to (7:3170495). See other errors for cause.

Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (7:3170496). The PageId in the page header = (0:0).

Server: Msg 8998, Level 16, State 1, Line 1

Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 91 pages from (7:3170496) to (7:3178583). See other errors for cause.

Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (7:3178584). The PageId in the page header = (0:0).

Server: Msg 8998, Level 16, State 1, Line 1

Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 91 pages from (7:3178584) to (7:3186671). See other errors for cause.

Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (7:3186672). The PageId in the page header = (0:0).

Server: Msg 8998, Level 16, State 1, Line 1

Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 91 pages from (7:3186672) to (7:3194759). See other errors for cause.

Server: Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID 0, page ID (7:3194760). The PageId in the page header = (0:0).

Server: Msg 8998, Level 16, State 1, Line 1

Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 91 pages from (7:3194760) to (7:3202847). See other errors for cause.

DBCC results for 'ProductionDB'.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-09 : 17:24:55

duplicate
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=112289

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources