I looked at the performance monitor for Repl. Pending Xacts and there is over 4billion transactions - there is NO WAY that there are that many that need to be replicated, espeically since the other subscriber only gets about 10,000 transactions per day. Now, if someone hit re-initialize subscription instead of hitting stop/start, would this create numbers that are that far out there? also, what can i do to see what transactions it says needs to be replicated and whether these are transactions from the publisher to the subscriber or from the subscriber to the publisher. That is really what i want to know - which direction are these 4billion transactions going, because both the distributor and the subscriber show 4billion pending xacts. Darin *** Sent via Developersdex http://www.developersdex.com ***
No, reinitializing will clear the slate. What you need to do is the following on your publisher: declare @subscriber_id int set @subscriber_id =0 declare @subscriber_db sysname set @subscriber_db ='Subscriber' declare @subscription_sequno varbinary(16) select @subscription_sequno = subscription_seqno From MSsubscriptions where subscriber_db=@subscriber_db and subscriber_id=@subscriber_id declare @publisher_database_id int declare @publisher_db sysname set @publisher_db ='Publisher' select @publisher_database_id= id from MSpublisher_databases where publisher_db =@Publisher_DB select count(*) from msrepl_transactions where xact_seqno>@subscription_sequno and publisher_database_id=@publisher_database_id "Darin" <darin_nospam@nospamever> wrote in message news:emZRqsI$IHA.1016@TK2MSFTNGP03.phx.gbl... >I looked at the performance monitor for Repl. Pending Xacts and there is > over 4billion transactions - there is NO WAY that there are that many > that need to be replicated, espeically since the other subscriber only > gets about 10,000 transactions per day. > > Now, if someone hit re-initialize subscription instead of hitting > stop/start, would this create numbers that are that far out there? also, > what can i do to see what transactions it says needs to be replicated > and whether these are transactions from the publisher to the subscriber > or from the subscriber to the publisher. That is really what i want to > know - which direction are these 4billion transactions going, because > both the distributor and the subscriber show 4billion pending xacts. > > Darin > > *** Sent via Developersdex http://www.developersdex.com ***
