sql server replication: Hi All,

I setup replication on a SQL 2k server, and it never
worked properly. I couldn't get it to sync. I called
Microsoft and they were not able to help. I tried to
disable replication but I recieved the following error:

Error 8646: The index entry for row id was not found in
index ID
2,of table 1312723729, in database 'NewtownSquare19'.

The ID was for MSMerge_contents.

I posted a few questions here and I received many good
ideas, but none of them worked. I called Microsoft and
they gave me a hot fix for the error, but that also didn't
work.

My thought now is to DTS every table in my database minus
all replication fields and all replication tables.

I am then going to back up the new database, uninstall SQL
and reinstall it. Then restore the DB back to the
original DB name. This should remove all traces of
replication on this server and my client application
should not know the difference.

Does this sound like a plausible solution? Does anyone
think there may be an issue with this DB? Is there
anything I should lookout for?

Any thoughts and comments would be greatly appreciated.

Thanks,
Joe

yes I did. =20

I also ran it with REPAIR_ALLOW_DATA_LOSS option.

There was only one non-replication table wiith an index=20
error.

I got all kinds of errors on the replication tables like:

Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc2MSmerge_contents' (ID=20
1312723729) (index ID 2). Extra or invalid key for the=20
keys:

Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:171976:0) with values (generation =3D 3329 and=20
tablenick =3D 6449124 and rowguid =3D 0D4F1526-D76B-49FD-8739-
4DDAA57A25C9d=A2>=11=10) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc2MSmerge_contents' (ID=20
1312723729) (index ID 2). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:185604:243) with values (generation =3D 3330=20
and tablenick =3D 6449125 and rowguid =3D DEF73CFD-DF07-421A-
B036-3AC8BCE442E5d=A2>=11=10) points to the data row identified=20
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc2MSmerge_contents' (ID=20
1312723729) (index ID 2). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:197792:68) with values (generation =3D 3330 and=20
tablenick =3D 6449125 and rowguid =3D D6B9DD00-44AB-4FE5-BD9D-
E2976DC45A9Ed=A2>=11=10) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc2MSmerge_contents' (ID=20
1312723729) (index ID 2). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:263951:277) with values (generation =3D 3363=20
and tablenick =3D 6449158 and rowguid =3D 29F65003-CE4D-4ED3-
B074-F84B9F6CF483d=A2>=11=10) points to the data row identified=20
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc3MSmerge_contents' (ID=20
1312723729) (index ID 3). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:205363:32) with values (partchangegen =3D NULL=20
and tablenick =3D 6449125 and rowguid =3D D6B9DD00-44AB-4FE5-
BD9D-E2976DC45A9Ed=A2>=11=10) points to the data row identified=20
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc3MSmerge_contents' (ID=20
1312723729) (index ID 3). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:227056:66) with values (partchangegen =3D NULL=20
and tablenick =3D 6449158 and rowguid =3D 29F65003-CE4D-4ED3-
B074-F84B9F6CF483d=A2>=11=10) points to the data row identified=20
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc3MSmerge_contents' (ID=20
1312723729) (index ID 3). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:248716:0) with values (partchangegen =3D NULL=20
and tablenick =3D 6449124 and rowguid =3D 0D4F1526-D76B-49FD-
8739-4DDAA57A25C9d=A2>=11=10) points to the data row identified=20
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc4MSmerge_contents' (ID=20
1312723729) (index ID 4). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:159152:115) with values (rowguid =3D 0D4F1526-
D76B-49FD-8739-4DDAA57A25C9d=A2>=11=10 and tablenick =3D 6449124=20
and rowguid =3D 0D4F1526-D76B-49FD-8739-4DDAA57A25C9d=A2>=11=10)=20
points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc4MSmerge_contents' (ID=20
1312723729) (index ID 4). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:171776:19) with values (rowguid =3D 29F65003-
CE4D-4ED3-B074-F84B9F6CF483d=A2>=11=10 and tablenick =3D 6449158=20
and rowguid =3D 29F65003-CE4D-4ED3-B074-F84B9F6CF483d=A2>=11=10)=20
points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',=20
index 'MSmerge_contents.nc4MSmerge_contents' (ID=20
1312723729) (index ID 4). Extra or invalid key for the=20
keys:
Server: Msg 8956, Level 16, State 1, Line 1

Thanks,

have you done DBCC CHECKDB()?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

No I dont have a backup.

When I try to restore this database I get an error on a
missing index as well. then the DB hangs and is real slow.

I have no ideas anymore

Thanks,

You do seem to have a lot of errors in there yes. Have you a backup taken
from earlier than this problem ?
If not then I would try to rebuild your replication scenrio on A.N.Other
server. It doesn't really matter whether replication is enabled there or
not so long as things are happy there.

If things go well then you will need to remove replication from the current
Sever and make sure it is all gone. You can then add it back and retry.


Report back how you get on/

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
yes I did.

I also ran it with REPAIR_ALLOW_DATA_LOSS option.

There was only one non-replication table wiith an index
error.

I got all kinds of errors on the replication tables like:

Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc2MSmerge_contents' (ID
1312723729) (index ID 2). Extra or invalid key for the
keys:

Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:171976:0) with values (generation = 3329 and
tablenick = 6449124 and rowguid = 0D4F1526-D76B-49FD-8739-
4DDAA57A25C9d¢>) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc2MSmerge_contents' (ID
1312723729) (index ID 2). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:185604:243) with values (generation = 3330
and tablenick = 6449125 and rowguid = DEF73CFD-DF07-421A-
B036-3AC8BCE442E5d¢>) points to the data row identified
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc2MSmerge_contents' (ID
1312723729) (index ID 2). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:197792:68) with values (generation = 3330 and
tablenick = 6449125 and rowguid = D6B9DD00-44AB-4FE5-BD9D-
E2976DC45A9Ed¢>) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc2MSmerge_contents' (ID
1312723729) (index ID 2). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:263951:277) with values (generation = 3363
and tablenick = 6449158 and rowguid = 29F65003-CE4D-4ED3-
B074-F84B9F6CF483d¢>) points to the data row identified
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc3MSmerge_contents' (ID
1312723729) (index ID 3). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:205363:32) with values (partchangegen = NULL
and tablenick = 6449125 and rowguid = D6B9DD00-44AB-4FE5-
BD9D-E2976DC45A9Ed¢>) points to the data row identified
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc3MSmerge_contents' (ID
1312723729) (index ID 3). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:227056:66) with values (partchangegen = NULL
and tablenick = 6449158 and rowguid = 29F65003-CE4D-4ED3-
B074-F84B9F6CF483d¢>) points to the data row identified
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc3MSmerge_contents' (ID
1312723729) (index ID 3). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:248716:0) with values (partchangegen = NULL
and tablenick = 6449124 and rowguid = 0D4F1526-D76B-49FD-
8739-4DDAA57A25C9d¢>) points to the data row identified
by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc4MSmerge_contents' (ID
1312723729) (index ID 4). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:159152:115) with values (rowguid = 0D4F1526-
D76B-49FD-8739-4DDAA57A25C9d¢> and tablenick = 6449124
and rowguid = 0D4F1526-D76B-49FD-8739-4DDAA57A25C9d¢>)
points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc4MSmerge_contents' (ID
1312723729) (index ID 4). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:171776:19) with values (rowguid = 29F65003-
CE4D-4ED3-B074-F84B9F6CF483d¢> and tablenick = 6449158
and rowguid = 29F65003-CE4D-4ED3-B074-F84B9F6CF483d¢>)
points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'NewtownSquare19',
index 'MSmerge_contents.nc4MSmerge_contents' (ID
1312723729) (index ID 4). Extra or invalid key for the
keys:
Server: Msg 8956, Level 16, State 1, Line 1

Thanks,
Joe