1) look at the xact_id column on msrepl_transactions. This will give you an
idea what has been applied and what is yet to be applied. You can compare
this value with the value of transaction_timestamp in
Msreplication_Subscriptions in the subscriber database.
2) its hard to say. Could a user be modifying data on the subscriber? Are
you using cascading updates/deletes on the publisher and not replicating
them? Perhaps a deferred update is causing the problem.
Note that if you use the continue on data consistency error profile your
agent will not stop when encountering this problem. The catch with this is
that if you don't know what is causing this problem the lack consistency
problem in the first place you might end up with a database which is quite
inconsistent from your publisher. Try running profiler on the publisher and
subscriber for extended periods until you see this problem and then try to
figure out what is causing it.
--
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 [quoted text, click to view] "Mark Miller" <mark_n_0-s*p..am@maxpreps.com> wrote in message
news:uEb%230PQyGHA.1252@TK2MSFTNGP04.phx.gbl...
> I'm running SQL 2005 SP1 and have setup transactional replication to 3
> subscribers. The publisher is it's own distributor. I have several tables
> that are filtered and I keep getting a rows missing error on these tables.
> I have rebuilt replication several times but I keep ending up with the
> same problem. So I have 2 questions:
>
> 1) I can see the commands using sp_browserreplcmds @article_id: How can I
> determine which commands to rerun and how can I apply them at the
> subscribers?
>
> 2) How can I determine what is causing the problem. Following are the
> schema and article filter for the article currently experiencing the
> problem:
>
> SCHEMA:
>
> CREATE TABLE [dbo].[table_athlete](
> [ID] [uniqueidentifier] NOT NULL,
> [SchoolID] [uniqueidentifier] NOT NULL,
> [FirstName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
> [LastName] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
> [Username] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
> [Password] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
> [Deleted] [bit] NOT NULL,
> CONSTRAINT [PK_table_athlete] PRIMARY KEY NONCLUSTERED
> (
> [ID] ASC
> )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON
> [PRIMARY]
> ) ON [PRIMARY]
>
> FILTER:
>
> [ID] IN (SELECT AthleteID FROM table_roster WHERE [AthleteID] = [ID] AND
> SSID IN (SELECT [ID] FROM table_sportseason WHERE ISNULL(InternalArchive,
> 0) = 0))
>
> Thanks,
>
> Mark
>
