Saturday, February 25, 2012

Possible chain linkage problem

We're getting these errors when DBCC database check about a possible chain
linkage problem. We're thinking that there's something wrong with a pointer
from an text field to the data. We can do a db repair but problem will show
up elsewhere. This only happens on the replicated database btw.
I'll bet it with a rid on one of the merge replication system tables. I've
seen this happen before and what has worked for me is to do the repair. I'm
wondering if you aren't having other disk problems.
Hilary Cotter
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
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:C12AEAA4-C571-4DB7-A46B-187C47A869CF@.microsoft.com...
> We're getting these errors when DBCC database check about a possible chain
> linkage problem. We're thinking that there's something wrong with a
> pointer
> from an text field to the data. We can do a db repair but problem will
> show
> up elsewhere. This only happens on the replicated database btw.

No comments:

Post a Comment