64-bit restore with error

Hi all,
I am testing SQL Server 2000 64-bit on Itanium2 and have hit a problem.
Our current production system is running SQL Server 2000 32-bit SP3a. I
backed up the database (about 200+ GB) and restored it on SQL Server 2000
64-bit. After the restore was completed, I did a dbcc_checkdb and it came
back with various errors (see below for sample). I repeated the restore from
the same backup on another 32-bit box and dbcc checkdb came out clean. Any
idea what's causing the errors in dbcc checkdb on the 64-bit restore?
They're fixable using the repair option but it takes a long time and it
isn't really inspiring confidence in our management.
Btw, OS on both is Windows Server 2003 Enterprise SP1.
Any help will be much appreciated.
Thanks!
aK.
Small snippet of error messages:
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'RSTBL1', index
'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:4242635:76) with values (DetailActivityCurID = 55833475 and
WorkorderCurID = 316630 and SetTypeID = 4869 and ? = NULL) points to the
data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'RSTBL1', index
'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:4242635:77) with values (DetailActivityCurID = 55833476 and
WorkorderCurID = 316630 and SetTypeID = 4870 and ? = NULL) points to the
data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'RSTBL1', index
'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:4242635:78) with values (DetailActivityCurID = 55833477 and
WorkorderCurID = 316630 and SetTypeID = 4869 and ? = 1) points to the data
row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'RSTBL1', index
'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:4242635:79) with values (DetailActivityCurID = 55833478 and
WorkorderCurID = 316630 and SetTypeID = 4870 and ? = 1) points to the data
row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'RSTBL1', index 'DetailActivityCur.akActivityDtime'
(ID 1218103380) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:4447340:155) with values (ActivityDtime = Jul 14 2005 4:47PM
and WorkorderCurID = 316630 and SetTypeID = 4868 and ? = NULL) points to the
data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'RSTBL1', index 'DetailActivityCur.akActivityDtime'
(ID 1218103380) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:4447340:160) with values (ActivityDtime = Jul 14 2005 4:47PM
and WorkorderCurID = 316630 and SetTypeID = 4868 and ? = 1) points to the
data row identified by ().
Server: Msg 8945, Level 16, State 1, Line 1
Table error: Object ID 1218103380, index ID 5 will be rebuilt.Hi
This looks like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;884856
You may want to upgrade the 32 bit edition to SP4 and then migrate (to the
same version).
John
"Angie" <NoSpam_angie_kong@.hotmail.NoSpam.com> wrote in message
news:OPpLxmYwFHA.908@.tk2msftngp13.phx.gbl...
> Hi all,
> I am testing SQL Server 2000 64-bit on Itanium2 and have hit a problem.
> Our current production system is running SQL Server 2000 32-bit SP3a. I
> backed up the database (about 200+ GB) and restored it on SQL Server 2000
> 64-bit. After the restore was completed, I did a dbcc_checkdb and it came
> back with various errors (see below for sample). I repeated the restore
> from the same backup on another 32-bit box and dbcc checkdb came out
> clean. Any idea what's causing the errors in dbcc checkdb on the 64-bit
> restore? They're fixable using the repair option but it takes a long time
> and it isn't really inspiring confidence in our management.
> Btw, OS on both is Windows Server 2003 Enterprise SP1.
> Any help will be much appreciated.
> Thanks!
> aK.
>
> Small snippet of error messages:
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:76) with values (DetailActivityCurID = 55833475 and
> WorkorderCurID = 316630 and SetTypeID = 4869 and ? = NULL) points to the
> data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:77) with values (DetailActivityCurID = 55833476 and
> WorkorderCurID = 316630 and SetTypeID = 4870 and ? = NULL) points to the
> data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:78) with values (DetailActivityCurID = 55833477 and
> WorkorderCurID = 316630 and SetTypeID = 4869 and ? = 1) points to the data
> row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:79) with values (DetailActivityCurID = 55833478 and
> WorkorderCurID = 316630 and SetTypeID = 4870 and ? = 1) points to the data
> row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index 'DetailActivityCur.akActivityDtime'
> (ID 1218103380) (index ID 4). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4447340:155) with values (ActivityDtime = Jul 14 2005 4:47PM
> and WorkorderCurID = 316630 and SetTypeID = 4868 and ? = NULL) points to
> the data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index 'DetailActivityCur.akActivityDtime'
> (ID 1218103380) (index ID 4). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4447340:160) with values (ActivityDtime = Jul 14 2005 4:47PM
> and WorkorderCurID = 316630 and SetTypeID = 4868 and ? = 1) points to the
> data row identified by ().
> Server: Msg 8945, Level 16, State 1, Line 1
> Table error: Object ID 1218103380, index ID 5 will be rebuilt.
>|||This should process should work fine. What builds are the servers on? SP3a
or above and having the same build number on both servers will probably make
these go away.
"Angie" <NoSpam_angie_kong@.hotmail.NoSpam.com> wrote in message
news:OPpLxmYwFHA.908@.tk2msftngp13.phx.gbl...
> Hi all,
> I am testing SQL Server 2000 64-bit on Itanium2 and have hit a problem.
> Our current production system is running SQL Server 2000 32-bit SP3a. I
> backed up the database (about 200+ GB) and restored it on SQL Server 2000
> 64-bit. After the restore was completed, I did a dbcc_checkdb and it came
> back with various errors (see below for sample). I repeated the restore
> from the same backup on another 32-bit box and dbcc checkdb came out
> clean. Any idea what's causing the errors in dbcc checkdb on the 64-bit
> restore? They're fixable using the repair option but it takes a long time
> and it isn't really inspiring confidence in our management.
> Btw, OS on both is Windows Server 2003 Enterprise SP1.
> Any help will be much appreciated.
> Thanks!
> aK.
>
> Small snippet of error messages:
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:76) with values (DetailActivityCurID = 55833475 and
> WorkorderCurID = 316630 and SetTypeID = 4869 and ? = NULL) points to the
> data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:77) with values (DetailActivityCurID = 55833476 and
> WorkorderCurID = 316630 and SetTypeID = 4870 and ? = NULL) points to the
> data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:78) with values (DetailActivityCurID = 55833477 and
> WorkorderCurID = 316630 and SetTypeID = 4869 and ? = 1) points to the data
> row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index
> 'DetailActivityCur.pkDetailActivityCur_ID' (ID 1218103380) (index ID 2).
> Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4242635:79) with values (DetailActivityCurID = 55833478 and
> WorkorderCurID = 316630 and SetTypeID = 4870 and ? = 1) points to the data
> row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index 'DetailActivityCur.akActivityDtime'
> (ID 1218103380) (index ID 4). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4447340:155) with values (ActivityDtime = Jul 14 2005 4:47PM
> and WorkorderCurID = 316630 and SetTypeID = 4868 and ? = NULL) points to
> the data row identified by ().
> Server: Msg 8952, Level 16, State 1, Line 1
> Table error: Database 'RSTBL1', index 'DetailActivityCur.akActivityDtime'
> (ID 1218103380) (index ID 4). Extra or invalid key for the keys:
> Server: Msg 8956, Level 16, State 1, Line 1
> Index row (1:4447340:160) with values (ActivityDtime = Jul 14 2005 4:47PM
> and WorkorderCurID = 316630 and SetTypeID = 4868 and ? = 1) points to the
> data row identified by ().
> Server: Msg 8945, Level 16, State 1, Line 1
> Table error: Object ID 1218103380, index ID 5 will be rebuilt.
>