Hello,
I copied all objects and data of my database to a new one, I ran DBCC
CHECKDB(newdatabase) and it came out clean. Then I ran DBCC DBREINDEX on all
tables and now CHECKDB(newDatabase) returns errors:
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:517),
slot 1, text ID 4244111360 is not referenced.
The error seams to be in the sysindexes table, does anyone have any info on
how to prevent/repair this error?
Thanks in advance
Jose.
If you are running the latest service pack, you'd probably
want to open a case up with Microsoft Product Support to see
what's causing the problems. There is a combination of
conditions that can cause this error that was fixed with SP
3. You may want to check this article and see if it applies
to your case if you aren't on the latest service pack:
FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a
Text Column
http://support.microsoft.com/?id=281287
-Sue
On Wed, 7 Apr 2004 14:30:10 -0600, "Jose Ines Cantu
Arrambide" <joseine@.nospam.com> wrote:
>Hello,
> I copied all objects and data of my database to a new one, I ran DBCC
>CHECKDB(newdatabase) and it came out clean. Then I ran DBCC DBREINDEX on all
>tables and now CHECKDB(newDatabase) returns errors:
>
>Server: Msg 8964, Level 16, State 1, Line 1
>Table error: Object ID 2. The text, ntext, or image node at page (1:517),
>slot 1, text ID 4244111360 is not referenced.
>
>The error seams to be in the sysindexes table, does anyone have any info on
>how to prevent/repair this error?
>Thanks in advance
>Jose.
>
Showing posts with label dbcccheckdb. Show all posts
Showing posts with label dbcccheckdb. Show all posts
Wednesday, March 7, 2012
DBCC DBReindex Question
Hello,
I copied all objects and data of my database to a new one, I ran DBCC
CHECKDB(newdatabase) and it came out clean. Then I ran DBCC DBREINDEX on all
tables and now CHECKDB(newDatabase) returns errors:
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:517),
slot 1, text ID 4244111360 is not referenced.
The error seams to be in the sysindexes table, does anyone have any info on
how to prevent/repair this error?
Thanks in advance
Jose.If you are running the latest service pack, you'd probably
want to open a case up with Microsoft Product Support to see
what's causing the problems. There is a combination of
conditions that can cause this error that was fixed with SP
3. You may want to check this article and see if it applies
to your case if you aren't on the latest service pack:
FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a
Text Column
http://support.microsoft.com/?id=281287
-Sue
On Wed, 7 Apr 2004 14:30:10 -0600, "Jose Ines Cantu
Arrambide" <joseine@.nospam.com> wrote:
>Hello,
> I copied all objects and data of my database to a new one, I ran DBCC
>CHECKDB(newdatabase) and it came out clean. Then I ran DBCC DBREINDEX on al
l
>tables and now CHECKDB(newDatabase) returns errors:
>
>Server: Msg 8964, Level 16, State 1, Line 1
>Table error: Object ID 2. The text, ntext, or image node at page (1:517),
>slot 1, text ID 4244111360 is not referenced.
>
>The error seams to be in the sysindexes table, does anyone have any info on
>how to prevent/repair this error?
>Thanks in advance
>Jose.
>
I copied all objects and data of my database to a new one, I ran DBCC
CHECKDB(newdatabase) and it came out clean. Then I ran DBCC DBREINDEX on all
tables and now CHECKDB(newDatabase) returns errors:
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:517),
slot 1, text ID 4244111360 is not referenced.
The error seams to be in the sysindexes table, does anyone have any info on
how to prevent/repair this error?
Thanks in advance
Jose.If you are running the latest service pack, you'd probably
want to open a case up with Microsoft Product Support to see
what's causing the problems. There is a combination of
conditions that can cause this error that was fixed with SP
3. You may want to check this article and see if it applies
to your case if you aren't on the latest service pack:
FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a
Text Column
http://support.microsoft.com/?id=281287
-Sue
On Wed, 7 Apr 2004 14:30:10 -0600, "Jose Ines Cantu
Arrambide" <joseine@.nospam.com> wrote:
>Hello,
> I copied all objects and data of my database to a new one, I ran DBCC
>CHECKDB(newdatabase) and it came out clean. Then I ran DBCC DBREINDEX on al
l
>tables and now CHECKDB(newDatabase) returns errors:
>
>Server: Msg 8964, Level 16, State 1, Line 1
>Table error: Object ID 2. The text, ntext, or image node at page (1:517),
>slot 1, text ID 4244111360 is not referenced.
>
>The error seams to be in the sysindexes table, does anyone have any info on
>how to prevent/repair this error?
>Thanks in advance
>Jose.
>
Friday, February 17, 2012
DBCC CHECKDB Error
I am getting the following error after checking the database with DBCC
CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
option. But it is not repairing. I am not a professional DBA please advise
what to do.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:5604) with latch type SH. VerifyPageId
failed.
Hi,
Best solution will be to restore the database from a healthy backup and to
analyze further open a case with Microsoft product support.
These errors occurs when there is a Hardware issue, so contact your hardware
vendor and ask them to do a hardware diagonostic.
Replace the hardware if any fault is rectified
Thanks
Hari
SQL Server MVP
"Sarma" <Sarma@.discussions.microsoft.com> wrote in message
news:C9AD329A-1066-482E-AAC8-1248BD70FAE8@.microsoft.com...
>I am getting the following error after checking the database with DBCC
> CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
> option. But it is not repairing. I am not a professional DBA please advise
> what to do.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:5604) with latch type SH. VerifyPageId
> failed.
|||Here are my general recommendations for these types of situations.
Also, below is from Books Online, specific for this error number:
Severity Level 16
Message Text
Page P_ID in database ID DB_ID is allocated in the SGAM SGAM_P_ID and PFS PFS_P_ID, but was not
allocated in any IAM. PFS flags 'PFS_FLAGS'.
Explanation
A PFS page has one byte per page for all pages in the file interval it maps (approximately 64 Mb).
Each byte contains, among other things, a bit that, when set, indicates that the page is from a
mixed extent (that is, it is a mixed page).
An IAM page has, among other things, an array of eight page IDs (called the mixed page array) to
hold the mixed pages allocated to the index. Note that IAM pages themselves are mixed pages, but IAM
pages are not self-referential (that is, the IAM page ID itself is not stored in its own mixed page
array).
This message means that a page has the 'mixed page' bit set in its PFS byte, but the page was not
seen as an IAM page and was not seen in an IAM page's mixed page array.
Action
HARDWARE FAILURE
Run hardware diagnostics and correct any problems. Also examine the Microsoft Windows NT system
and application logs and the SQL ServerT error log to see if the error occurred as the result of
hardware failure. Fix any hardware related problems.
If you have persistent data corruption problems, try to swap out different hardware components to
isolate the problem. Check to ensure that your system does not have write caching enabled on the
disk controller. If you suspect this to be the problem, contact your hardware vendor.
Finally, you might find it beneficial to switch to a completely new hardware system, including
reformatting the disk drives and reinstalling the operating system.
RESTORE FROM BACKUP
If the problem is not hardware related and a known clean backup is available, restore the database
from the backup.
DBCC CHECKDB
If no clean backup is available, execute DBCC CHECKDB without a repair clause to determine the
extent of the corruption. DBCC CHECKDB will recommend a repair clause to use. Then, execute DBCC
CHECKDB with the appropriate repair clause to repair the corruption.
Caution If you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact
your primary support provider before executing this statement.
If the page is an IAM page, performing a repair will de-allocate the page, and the IAM chain will be
patched by the repairs for accompanying errors.
Otherwise, a general purpose routine to repair doubly allocated pages is used. It takes two sets of
IDs, one for each of the two indexes (IAM chains) that have the page allocated. In this case, we use
the IDs derived from the page itself, and an invalid set of IDs.
The algorithm of the general purpose routine is as follows:
1.. Check page validity.
a.. If the page is not a valid page ID in the database, de-allocate it from both indexes and
return.
b.. If the page is corrupt, de-allocate it from both indexes, then return.
2.. Work out which index the page actually belongs to.
3.. Check for the allocation page.
a.. If the page is an IAM page or allocation page, de-allocate it from both indexes passed in.
b.. If the page is an IAM page and the index it thinks it belongs to cannot be found,
de-allocate the page.
c.. Return.
4.. If the page belongs to the first index passed in:
a.. De-allocate it from the second index passed in.
b.. Try to allocate it to the first index. If this fails, de-allocate the page.
c.. Return.
Note We should not get below here for this particular error.
5.. De-allocate the page from the first index.
6.. If the page does not belong to second index:
a.. If the second index is not invalid, de-allocate the page from the second index.
b.. Try to allocate the page to the real owning index. If it fails, de-allocate the page.
c.. Return.
7.. Page must belong to second index passed in.
a.. Try to allocate the page to the second index. If it fails, de-allocate the page.
b.. Return.
Caution This repair may cause data loss.
If running DBCC CHECKDB with one of the repair clauses does not correct the problem, contact your
primary support provider.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sarma" <Sarma@.discussions.microsoft.com> wrote in message
news:C9AD329A-1066-482E-AAC8-1248BD70FAE8@.microsoft.com...
>I am getting the following error after checking the database with DBCC
> CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
> option. But it is not repairing. I am not a professional DBA please advise
> what to do.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:5604) with latch type SH. VerifyPageId
> failed.
begin 666 caution.gif
M1TE&.#EA# `+`/<``````#,``&8``)D``,P``/\````S`#,S`&8S`)DS`,PS
M`/\S``!F`#-F`&9F`)EF`,QF`/]F``"9`#.9`&:9`)F9`,R9`/^9``#,`#/,
M`&;,`)G,`,S,`/_,``#_`#/_`&;_`)G_`,S_`/__````,S,`,V8`,YD`,\P`
M,_\`,P`S,S,S,V8S,YDS,\PS,_\S,P!F,S-F,V9F,YEF,\QF,_]F,P"9,S.9
M,V:9,YF9,\R9,_^9,P#,,S/,,V;,,YG,,\S,,__,,P#_,S/_,V;_,YG_,\S_
M,___,P``9C,`9F8`9ID`9LP`9O\`9@.`S9C,S9F8S9IDS9LPS9 O\S9@.!F9C-F
M9F9F9IEF9LQF9O]F9@."99C.99F:99IF99LR99O^99@.#,9C/,9F;,9IG,9LS,
M9O_,9@.#_9C/_9F;_9IG_9LS_9O__9@.``F3,`F68`F9D`F<P`F?\`F0`SF3,S
MF68SF9DSF<PSF?\SF0!FF3-FF69FF9EFF<QFF?]FF0"9F3.9F6:9F9F9F<R9
MF?^9F0#,F3/,F6;,F9G,F<S,F?_,F0#_F3/_F6;_F9G_F<S_F?__F0``S#,`
MS&8`S)D`S,P`S/\`S `SS#,SS&8SS)DSS,PSS/\SS !FS#-FS&9FS)EFS,QF
MS/]FS "9S#.9S&:9S)F9S,R9S/^9S #,S#/,S&;,S)G,S,S,S/_,S #_S#/_
MS&;_S)G_S,S_S/__S ``_S,`_V8`_YD`_\P`__\`_P`S_S,S_V8S_YDS_\PS
M__\S_P!F_S-F_V9F_YEF_\QF__]F_P"9_S.9_V:9_YF9_\R9__^9_P#,_S/,
M_V;,_YG,_\S,___,_P#__S/__V;__YG__\S______P``````````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M`````````````````````"'Y! $``*P`+ `````,``L`0 @.B`%D)'$BPH,&#
;K HH1)AP(4*%!1A"9$A1X,2'#BMBC#@.P( `[
`
end
CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
option. But it is not repairing. I am not a professional DBA please advise
what to do.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:5604) with latch type SH. VerifyPageId
failed.
Hi,
Best solution will be to restore the database from a healthy backup and to
analyze further open a case with Microsoft product support.
These errors occurs when there is a Hardware issue, so contact your hardware
vendor and ask them to do a hardware diagonostic.
Replace the hardware if any fault is rectified
Thanks
Hari
SQL Server MVP
"Sarma" <Sarma@.discussions.microsoft.com> wrote in message
news:C9AD329A-1066-482E-AAC8-1248BD70FAE8@.microsoft.com...
>I am getting the following error after checking the database with DBCC
> CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
> option. But it is not repairing. I am not a professional DBA please advise
> what to do.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:5604) with latch type SH. VerifyPageId
> failed.
|||Here are my general recommendations for these types of situations.
Also, below is from Books Online, specific for this error number:
Severity Level 16
Message Text
Page P_ID in database ID DB_ID is allocated in the SGAM SGAM_P_ID and PFS PFS_P_ID, but was not
allocated in any IAM. PFS flags 'PFS_FLAGS'.
Explanation
A PFS page has one byte per page for all pages in the file interval it maps (approximately 64 Mb).
Each byte contains, among other things, a bit that, when set, indicates that the page is from a
mixed extent (that is, it is a mixed page).
An IAM page has, among other things, an array of eight page IDs (called the mixed page array) to
hold the mixed pages allocated to the index. Note that IAM pages themselves are mixed pages, but IAM
pages are not self-referential (that is, the IAM page ID itself is not stored in its own mixed page
array).
This message means that a page has the 'mixed page' bit set in its PFS byte, but the page was not
seen as an IAM page and was not seen in an IAM page's mixed page array.
Action
HARDWARE FAILURE
Run hardware diagnostics and correct any problems. Also examine the Microsoft Windows NT system
and application logs and the SQL ServerT error log to see if the error occurred as the result of
hardware failure. Fix any hardware related problems.
If you have persistent data corruption problems, try to swap out different hardware components to
isolate the problem. Check to ensure that your system does not have write caching enabled on the
disk controller. If you suspect this to be the problem, contact your hardware vendor.
Finally, you might find it beneficial to switch to a completely new hardware system, including
reformatting the disk drives and reinstalling the operating system.
RESTORE FROM BACKUP
If the problem is not hardware related and a known clean backup is available, restore the database
from the backup.
DBCC CHECKDB
If no clean backup is available, execute DBCC CHECKDB without a repair clause to determine the
extent of the corruption. DBCC CHECKDB will recommend a repair clause to use. Then, execute DBCC
CHECKDB with the appropriate repair clause to repair the corruption.
Caution If you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact
your primary support provider before executing this statement.
If the page is an IAM page, performing a repair will de-allocate the page, and the IAM chain will be
patched by the repairs for accompanying errors.
Otherwise, a general purpose routine to repair doubly allocated pages is used. It takes two sets of
IDs, one for each of the two indexes (IAM chains) that have the page allocated. In this case, we use
the IDs derived from the page itself, and an invalid set of IDs.
The algorithm of the general purpose routine is as follows:
1.. Check page validity.
a.. If the page is not a valid page ID in the database, de-allocate it from both indexes and
return.
b.. If the page is corrupt, de-allocate it from both indexes, then return.
2.. Work out which index the page actually belongs to.
3.. Check for the allocation page.
a.. If the page is an IAM page or allocation page, de-allocate it from both indexes passed in.
b.. If the page is an IAM page and the index it thinks it belongs to cannot be found,
de-allocate the page.
c.. Return.
4.. If the page belongs to the first index passed in:
a.. De-allocate it from the second index passed in.
b.. Try to allocate it to the first index. If this fails, de-allocate the page.
c.. Return.
Note We should not get below here for this particular error.
5.. De-allocate the page from the first index.
6.. If the page does not belong to second index:
a.. If the second index is not invalid, de-allocate the page from the second index.
b.. Try to allocate the page to the real owning index. If it fails, de-allocate the page.
c.. Return.
7.. Page must belong to second index passed in.
a.. Try to allocate the page to the second index. If it fails, de-allocate the page.
b.. Return.
Caution This repair may cause data loss.
If running DBCC CHECKDB with one of the repair clauses does not correct the problem, contact your
primary support provider.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sarma" <Sarma@.discussions.microsoft.com> wrote in message
news:C9AD329A-1066-482E-AAC8-1248BD70FAE8@.microsoft.com...
>I am getting the following error after checking the database with DBCC
> CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
> option. But it is not repairing. I am not a professional DBA please advise
> what to do.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:5604) with latch type SH. VerifyPageId
> failed.
begin 666 caution.gif
M1TE&.#EA# `+`/<``````#,``&8``)D``,P``/\````S`#,S`&8S`)DS`,PS
M`/\S``!F`#-F`&9F`)EF`,QF`/]F``"9`#.9`&:9`)F9`,R9`/^9``#,`#/,
M`&;,`)G,`,S,`/_,``#_`#/_`&;_`)G_`,S_`/__````,S,`,V8`,YD`,\P`
M,_\`,P`S,S,S,V8S,YDS,\PS,_\S,P!F,S-F,V9F,YEF,\QF,_]F,P"9,S.9
M,V:9,YF9,\R9,_^9,P#,,S/,,V;,,YG,,\S,,__,,P#_,S/_,V;_,YG_,\S_
M,___,P``9C,`9F8`9ID`9LP`9O\`9@.`S9C,S9F8S9IDS9LPS9 O\S9@.!F9C-F
M9F9F9IEF9LQF9O]F9@."99C.99F:99IF99LR99O^99@.#,9C/,9F;,9IG,9LS,
M9O_,9@.#_9C/_9F;_9IG_9LS_9O__9@.``F3,`F68`F9D`F<P`F?\`F0`SF3,S
MF68SF9DSF<PSF?\SF0!FF3-FF69FF9EFF<QFF?]FF0"9F3.9F6:9F9F9F<R9
MF?^9F0#,F3/,F6;,F9G,F<S,F?_,F0#_F3/_F6;_F9G_F<S_F?__F0``S#,`
MS&8`S)D`S,P`S/\`S `SS#,SS&8SS)DSS,PSS/\SS !FS#-FS&9FS)EFS,QF
MS/]FS "9S#.9S&:9S)F9S,R9S/^9S #,S#/,S&;,S)G,S,S,S/_,S #_S#/_
MS&;_S)G_S,S_S/__S ``_S,`_V8`_YD`_\P`__\`_P`S_S,S_V8S_YDS_\PS
M__\S_P!F_S-F_V9F_YEF_\QF__]F_P"9_S.9_V:9_YF9_\R9__^9_P#,_S/,
M_V;,_YG,_\S,___,_P#__S/__V;__YG__\S______P``````````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M`````````````````````"'Y! $``*P`+ `````,``L`0 @.B`%D)'$BPH,&#
;K HH1)AP(4*%!1A"9$A1X,2'#BMBC#@.P( `[
`
end
Tuesday, February 14, 2012
DBCC CHECKDB Error
I am getting the following error after checking the database with DBCC
CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
option. But it is not repairing. I am not a professional DBA please advise
what to do.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:5604) with latch type SH. VerifyPageId
failed.Hi,
Best solution will be to restore the database from a healthy backup and to
analyze further open a case with Microsoft product support.
These errors occurs when there is a hardware issue, so contact your hardware
vendor and ask them to do a hardware diagonostic.
Replace the hardware if any fault is rectified
Thanks
Hari
SQL Server MVP
"Sarma" <Sarma@.discussions.microsoft.com> wrote in message
news:C9AD329A-1066-482E-AAC8-1248BD70FAE8@.microsoft.com...
>I am getting the following error after checking the database with DBCC
> CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
> option. But it is not repairing. I am not a professional DBA please advise
> what to do.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:5604) with latch type SH. VerifyPageId
> failed.
CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
option. But it is not repairing. I am not a professional DBA please advise
what to do.
Server: Msg 8906, Level 16, State 1, Line 1
Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:1),
but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
0_PCT_FULL'.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:5604) with latch type SH. VerifyPageId
failed.Hi,
Best solution will be to restore the database from a healthy backup and to
analyze further open a case with Microsoft product support.
These errors occurs when there is a hardware issue, so contact your hardware
vendor and ask them to do a hardware diagonostic.
Replace the hardware if any fault is rectified
Thanks
Hari
SQL Server MVP
"Sarma" <Sarma@.discussions.microsoft.com> wrote in message
news:C9AD329A-1066-482E-AAC8-1248BD70FAE8@.microsoft.com...
>I am getting the following error after checking the database with DBCC
> CHECKDB('DATABASE NAME'). We tried to repair with repair_allow_data_loos
> option. But it is not repairing. I am not a professional DBA please advise
> what to do.
> Server: Msg 8906, Level 16, State 1, Line 1
> Page (1:5604) in database ID 7 is allocated in the SGAM (1:3) and PFS
> (1:1),
> but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED
> 0_PCT_FULL'.
> Server: Msg 8966, Level 16, State 1, Line 1
> Could not read and latch page (1:5604) with latch type SH. VerifyPageId
> failed.
DBCC CHECKDB (database) WITH ALL_ERRORMSGS
Yesterday, I received approximately 200 error messages from the T-SQL DBCC
CHECKDB(database) WITH ALL_ERRORMSGS command.
Listed below are some of the output errors that I received.
Please let me know the best way to resolve these errors.
Thank You,
DBCC results for 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:80654) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:80654). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:81930) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:81930). Test
(m_freeCnt == freeCnt) failed. Values are 207 and 239.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:75016) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:75016). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81936) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81936). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81938) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81938). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:83168) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:83168). Test
(m_freeCnt == freeCnt) failed. Values are 219 and 251.
There are 254060 rows in 6235 pages for object 'USER_ATTR'.
CHECKDB found 0 allocation errors and 8 consistency errors in table
'USER_ATTR' (object ID 826486023).
DBCC results for 'ATTRIBUTE_SUMMARY'.
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
in the scan although its parent (1:15408) and previous (1:76422) refer to it
.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
reference from previous page (1:80730). Possible chain linkage problem.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1975730141, index ID 4: Page (1:79858) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
in the scan although its parent (1:81368) and previous (1:74375) refer to it
.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
reference from previous page (1:79858). Possible chain linkage problem.
There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
CHECKDB found 0 allocation errors and 12 consistency errors in table
'ATTRIBUTE_SUMMARY' (You might want to review this
http://forums.microsoft.com/MSDN/Sh...738137&SiteID=1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:57321F20-58C5-4BA8-9EA4-2222531294F9@.microsoft.com...
> Yesterday, I received approximately 200 error messages from the T-SQL DBCC
> CHECKDB(database) WITH ALL_ERRORMSGS command.
> Listed below are some of the output errors that I received.
> Please let me know the best way to resolve these errors.
> Thank You,
>
> DBCC results for 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:80654) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:80654). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:81930) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:81930). Test
> (m_freeCnt == freeCnt) failed. Values are 207 and 239.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:75016) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:75016). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81936) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81936). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81938) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81938). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:83168) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:83168). Test
> (m_freeCnt == freeCnt) failed. Values are 219 and 251.
> There are 254060 rows in 6235 pages for object 'USER_ATTR'.
> CHECKDB found 0 allocation errors and 8 consistency errors in table
> 'USER_ATTR' (object ID 826486023).
>
> DBCC results for 'ATTRIBUTE_SUMMARY'.
> Server: Msg 8939, Level 16, State 106, Line 1
> Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
> in the scan although its parent (1:15408) and previous (1:76422) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
> reference from previous page (1:80730). Possible chain linkage problem.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1975730141, index ID 4: Page (1:79858) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
> in the scan although its parent (1:81368) and previous (1:74375) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
> reference from previous page (1:79858). Possible chain linkage problem.
> There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
> CHECKDB found 0 allocation errors and 12 consistency errors in table
> 'ATTRIBUTE_SUMMARY' (
CHECKDB(database) WITH ALL_ERRORMSGS command.
Listed below are some of the output errors that I received.
Please let me know the best way to resolve these errors.
Thank You,
DBCC results for 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:80654) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:80654). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:81930) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:81930). Test
(m_freeCnt == freeCnt) failed. Values are 207 and 239.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:75016) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:75016). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81936) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81936). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81938) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81938). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:83168) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:83168). Test
(m_freeCnt == freeCnt) failed. Values are 219 and 251.
There are 254060 rows in 6235 pages for object 'USER_ATTR'.
CHECKDB found 0 allocation errors and 8 consistency errors in table
'USER_ATTR' (object ID 826486023).
DBCC results for 'ATTRIBUTE_SUMMARY'.
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
in the scan although its parent (1:15408) and previous (1:76422) refer to it
.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
reference from previous page (1:80730). Possible chain linkage problem.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1975730141, index ID 4: Page (1:79858) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
in the scan although its parent (1:81368) and previous (1:74375) refer to it
.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
reference from previous page (1:79858). Possible chain linkage problem.
There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
CHECKDB found 0 allocation errors and 12 consistency errors in table
'ATTRIBUTE_SUMMARY' (You might want to review this
http://forums.microsoft.com/MSDN/Sh...738137&SiteID=1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:57321F20-58C5-4BA8-9EA4-2222531294F9@.microsoft.com...
> Yesterday, I received approximately 200 error messages from the T-SQL DBCC
> CHECKDB(database) WITH ALL_ERRORMSGS command.
> Listed below are some of the output errors that I received.
> Please let me know the best way to resolve these errors.
> Thank You,
>
> DBCC results for 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:80654) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:80654). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:81930) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:81930). Test
> (m_freeCnt == freeCnt) failed. Values are 207 and 239.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:75016) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:75016). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81936) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81936). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81938) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81938). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:83168) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:83168). Test
> (m_freeCnt == freeCnt) failed. Values are 219 and 251.
> There are 254060 rows in 6235 pages for object 'USER_ATTR'.
> CHECKDB found 0 allocation errors and 8 consistency errors in table
> 'USER_ATTR' (object ID 826486023).
>
> DBCC results for 'ATTRIBUTE_SUMMARY'.
> Server: Msg 8939, Level 16, State 106, Line 1
> Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
> in the scan although its parent (1:15408) and previous (1:76422) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
> reference from previous page (1:80730). Possible chain linkage problem.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1975730141, index ID 4: Page (1:79858) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
> in the scan although its parent (1:81368) and previous (1:74375) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
> reference from previous page (1:79858). Possible chain linkage problem.
> There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
> CHECKDB found 0 allocation errors and 12 consistency errors in table
> 'ATTRIBUTE_SUMMARY' (
DBCC CHECKDB (database) WITH ALL_ERRORMSGS
Yesterday, I received approximately 200 error messages from the T-SQL DBCC
CHECKDB(database) WITH ALL_ERRORMSGS command.
Listed below are some of the output errors that I received.
Please let me know the best way to resolve these errors.
Thank You,
DBCC results for 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:80654) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:80654). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:81930) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:81930). Test
(m_freeCnt == freeCnt) failed. Values are 207 and 239.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:75016) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:75016). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81936) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81936). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81938) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81938). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:83168) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:83168). Test
(m_freeCnt == freeCnt) failed. Values are 219 and 251.
There are 254060 rows in 6235 pages for object 'USER_ATTR'.
CHECKDB found 0 allocation errors and 8 consistency errors in table
'USER_ATTR' (object ID 826486023).
DBCC results for 'ATTRIBUTE_SUMMARY'.
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
in the scan although its parent (1:15408) and previous (1:76422) refer to it.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
reference from previous page (1:80730). Possible chain linkage problem.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1975730141, index ID 4: Page (1:79858) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
in the scan although its parent (1:81368) and previous (1:74375) refer to it.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
reference from previous page (1:79858). Possible chain linkage problem.
There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
CHECKDB found 0 allocation errors and 12 consistency errors in table
'ATTRIBUTE_SUMMARY' (
You might want to review this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738137&SiteID=1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:57321F20-58C5-4BA8-9EA4-2222531294F9@.microsoft.com...
> Yesterday, I received approximately 200 error messages from the T-SQL DBCC
> CHECKDB(database) WITH ALL_ERRORMSGS command.
> Listed below are some of the output errors that I received.
> Please let me know the best way to resolve these errors.
> Thank You,
>
> DBCC results for 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:80654) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:80654). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:81930) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:81930). Test
> (m_freeCnt == freeCnt) failed. Values are 207 and 239.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:75016) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:75016). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81936) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81936). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81938) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81938). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:83168) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:83168). Test
> (m_freeCnt == freeCnt) failed. Values are 219 and 251.
> There are 254060 rows in 6235 pages for object 'USER_ATTR'.
> CHECKDB found 0 allocation errors and 8 consistency errors in table
> 'USER_ATTR' (object ID 826486023).
>
> DBCC results for 'ATTRIBUTE_SUMMARY'.
> Server: Msg 8939, Level 16, State 106, Line 1
> Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
> in the scan although its parent (1:15408) and previous (1:76422) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
> reference from previous page (1:80730). Possible chain linkage problem.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1975730141, index ID 4: Page (1:79858) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
> in the scan although its parent (1:81368) and previous (1:74375) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
> reference from previous page (1:79858). Possible chain linkage problem.
> There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
> CHECKDB found 0 allocation errors and 12 consistency errors in table
> 'ATTRIBUTE_SUMMARY' (
CHECKDB(database) WITH ALL_ERRORMSGS command.
Listed below are some of the output errors that I received.
Please let me know the best way to resolve these errors.
Thank You,
DBCC results for 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:80654) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:80654). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 797961919, index ID 0: Page (1:81930) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 797961919, index ID 0, page (1:81930). Test
(m_freeCnt == freeCnt) failed. Values are 207 and 239.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:75016) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:75016). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81936) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81936). Test
(m_freeCnt == freeCnt) failed. Values are 221 and 253.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:81938) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:81938). Test
(m_freeCnt == freeCnt) failed. Values are 213 and 245.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 826486023, index ID 0: Page (1:83168) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 826486023, index ID 0, page (1:83168). Test
(m_freeCnt == freeCnt) failed. Values are 219 and 251.
There are 254060 rows in 6235 pages for object 'USER_ATTR'.
CHECKDB found 0 allocation errors and 8 consistency errors in table
'USER_ATTR' (object ID 826486023).
DBCC results for 'ATTRIBUTE_SUMMARY'.
Server: Msg 8939, Level 16, State 106, Line 1
Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
in the scan although its parent (1:15408) and previous (1:76422) refer to it.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
reference from previous page (1:80730). Possible chain linkage problem.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1975730141, index ID 4: Page (1:79858) could not be processed. See
other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
(m_freeCnt == freeCnt) failed. Values are 24 and 56.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
in the scan although its parent (1:81368) and previous (1:74375) refer to it.
Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
reference from previous page (1:79858). Possible chain linkage problem.
There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
CHECKDB found 0 allocation errors and 12 consistency errors in table
'ATTRIBUTE_SUMMARY' (
You might want to review this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=738137&SiteID=1
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:57321F20-58C5-4BA8-9EA4-2222531294F9@.microsoft.com...
> Yesterday, I received approximately 200 error messages from the T-SQL DBCC
> CHECKDB(database) WITH ALL_ERRORMSGS command.
> Listed below are some of the output errors that I received.
> Please let me know the best way to resolve these errors.
> Thank You,
>
> DBCC results for 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:80654) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:80654). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 797961919, index ID 0: Page (1:81930) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 797961919, index ID 0, page (1:81930). Test
> (m_freeCnt == freeCnt) failed. Values are 207 and 239.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:75016) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:75016). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> There are 3549 rows in 58 pages for object 'ACC_CNTRL_LOG'.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81936) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81936). Test
> (m_freeCnt == freeCnt) failed. Values are 221 and 253.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:81938) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:81938). Test
> (m_freeCnt == freeCnt) failed. Values are 213 and 245.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 826486023, index ID 0: Page (1:83168) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 826486023, index ID 0, page (1:83168). Test
> (m_freeCnt == freeCnt) failed. Values are 219 and 251.
> There are 254060 rows in 6235 pages for object 'USER_ATTR'.
> CHECKDB found 0 allocation errors and 8 consistency errors in table
> 'USER_ATTR' (object ID 826486023).
>
> DBCC results for 'ATTRIBUTE_SUMMARY'.
> Server: Msg 8939, Level 16, State 106, Line 1
> Table error: Object ID 1975730141, index ID 3, page (1:80730). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:80730) was not seen
> in the scan although its parent (1:15408) and previous (1:76422) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 3. Page (1:84752) is missing a
> reference from previous page (1:80730). Possible chain linkage problem.
> Server: Msg 8928, Level 16, State 1, Line 1
> Object ID 1975730141, index ID 4: Page (1:79858) could not be processed.
> See
> other errors for details.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4, page (1:79858). Test
> (m_freeCnt == freeCnt) failed. Values are 24 and 56.
> Server: Msg 8976, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:79858) was not seen
> in the scan although its parent (1:81368) and previous (1:74375) refer to
> it.
> Check any previous errors.
> Server: Msg 8978, Level 16, State 1, Line 1
> Table error: Object ID 1975730141, index ID 4. Page (1:84893) is missing a
> reference from previous page (1:79858). Possible chain linkage problem.
> There are 153206 rows in 3650 pages for object 'ATTRIBUTE_SUMMARY'.
> CHECKDB found 0 allocation errors and 12 consistency errors in table
> 'ATTRIBUTE_SUMMARY' (
Subscribe to:
Posts (Atom)