April 20, 2005 at 7:01 am
We have replication set up from our production system to 3 other servers. MSrepl_commands table on distribution database was filling up as a result someone tried EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 0 which deleted all rows from this table . soon after that replication failed completely and the error shows up as
"The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated." followed by
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
(Source: DISTRIBUTION (Data source); Error number: 21074). Has anyone seen thsi error before and if so is there a remedy to this. we had our max retention set to 336 hrs but since it was forced to run with 0 did it cleanup data from the distribution database that had to be replicated. Since its the prodn system any help on this will be greatly appreciated.
TIA
April 25, 2005 at 8:00 am
This was removed by the editor as SPAM
March 16, 2007 at 12:34 am
Could try using the "Subscription never expire" option and reinitialize.
If this does not work , keep the last option as updating the table status
with 2 which is active state, and start the agent.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply