The subscription(s) have been marked inactive and must be reinitialized.
- From: "ishaan99 via SQLMonster.com" <forum@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Apr 2005 12:50:32 GMT
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
--
Message posted via http://www.sqlmonster.com
.
- Follow-Ups:
- Re: The subscription(s) have been marked inactive and must be reinitialized.
- From: Hilary Cotter
- Re: The subscription(s) have been marked inactive and must be reinitialized.
- Prev by Date: Re: Row filtering
- Next by Date: Replicating everything but deletes
- Previous by thread: Re: Row filtering
- Next by thread: Re: The subscription(s) have been marked inactive and must be reinitialized.
- Index(es):
Relevant Pages
|
