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.
>

No comments:

Post a Comment