Hi Guys im newbie but need to learn more of it so please cooperate with me and slolve my problem.
my Sql Server starts merging and it starts dumping the scema and data after some time it the status shows failed, it doesn't give any error message also. please let me know what to check and how to resolve this.
The merge agent must be saying something? Are you looking at the SQL Serrve agent job history?
Also you can try running the merge agent from command line with increased verbosity. -OutputVerboseLevel 2
|||yeah there is an error saying that
" The process could not deliver the snapshot to the subscriber. Note:The step was was retried the requested number of times(10) without succeeding. the step faild."
So please let me know wht to do on this. Thanks and Praises in advance.
|||Try one of all of the following:
1. Can you expand all the + in the job history view and see if there is any relevant information there.
2. Run the merge agent from command line tool D:\Program FIles\Microsoft SQL Server\90\COM\replmerg.exe with all the relevant parameters and also add -OutputVerboseLevel 2
3. Look in distribution..MSmerge_history for the error message for this session.
No comments:
Post a Comment