SQL Server Performance Forum – Threads Archive
Replication
Even after reinitializing I keep on getting this error message and problem with replication. Bluethunder and MorningSide are servers and "security" is the table nameDESCRIPTION: Error: 14151, Severity: 18, State: 1 Replication-Replication Distribution Subsystem: agent BLUETHUNDER-security-MORNINGSIDE-154 failed. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
How can I work around this issue
have u selected the subscription never expires option ? you gets the error while reintialising or after few days of reinitialisation? Ref:
http://msdn2.microsoft.com/en-us/library/ms151188.aspx
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18580 In BOL : ubscription Expiration and Deactivation Madhu
What is the setting of maximum disretention> Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
did you try to recreate the replication again. if not try it. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
We did initialize and set up replication a couple of times. We have increased the transaction retention time from 72 hours to 336 hours.
I know this is not related but have you tried restarting SQLAgent in thsi case? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>