Dear All
I am getting this error during indexing on the table. What should i do to
solve this problem
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:48528) has invalid PFS_PAGE page header
values. Type is 0. Check type, object ID and page ID on the page.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID -1, index ID 65535, page (1:48528). Test (IS_ON
(BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts.
Possibly tempdb out of space or a system table is inconsistent. Check
previous errors.
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 15 pages from (1:48528) to (1:56615). See other errors for cause
.
The repair level on the DBCC statement caused this repair to be
bypassed.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID -1)' (object ID -1).
DBCC results for 'infodrive_query'.
The repair level on the DBCC statement caused this repair to be
bypassed.
CHECKDB found 1 allocation errors and 0 consistency errors not associated
with any single object.
DBCC results for 'sysobjects'.
There are 87 rows in 1 pages for object 'sysobjects'.
CHECKDB found 2 allocation errors and 0 consistency errors in database
'Infodrive_Query'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Thanks & regards
Manoj kumarManoj
> CHECKTABLE terminated. A failure was detected while collecting facts.
> Possibly tempdb out of space or a system table is inconsistent. Check
> previous errors.
Check these above options. I assume you don't create an index on system
table.
Identify what is the object that has corrupted index. Drop this index and
try re-create again
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:6C43A8D4-4FE3-4303-8E51-64D436CB33CE@.microsoft.com...
> Dear All
> I am getting this error during indexing on the table. What should i do to
> solve this problem
>
> Server: Msg 8946, Level 16, State 12, Line 2
> Table error: Allocation page (1:48528) has invalid PFS_PAGE page header
> values. Type is 0. Check type, object ID and page ID on the page.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID -1, index ID 65535, page (1:48528). Test (IS_ON
> (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
> and -1.
> Server: Msg 8921, Level 16, State 1, Line 1
> CHECKTABLE terminated. A failure was detected while collecting facts.
> Possibly tempdb out of space or a system table is inconsistent. Check
> previous errors.
> 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 15 pages from (1:48528) to (1:56615). See other errors for
> cause.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> CHECKDB found 1 allocation errors and 0 consistency errors in table
> '(Object
> ID -1)' (object ID -1).
> DBCC results for 'infodrive_query'.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> CHECKDB found 1 allocation errors and 0 consistency errors not associated
> with any single object.
> DBCC results for 'sysobjects'.
> There are 87 rows in 1 pages for object 'sysobjects'.
> CHECKDB found 2 allocation errors and 0 consistency errors in database
> 'Infodrive_Query'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> Thanks & regards
> Manoj kumar
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment