InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:02:55 GMT20http://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxdave,Sorry, I take that back. I was looking at the wrong subscription propertiers this morning. Meaning, the correct subscription property is showing correct publisher and subscriber. However, the syncronization is showing below message, if you can explain what that means..The concurrent snapshot for publication 'ADT_Tables_For_100.60' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent fo[/b]Thanks again,HemantThu, 15 Nov 2012 20:07:36 GMTHemant Kordehttp://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxGreat. Glad that worked. If that wasn't the issue I was going to be hitting the "stumped" button pretty quickly. :)Thu, 15 Nov 2012 08:30:49 GMTDavid Benoithttp://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxDavid, thank you so much. You solved my probelm. I did find that the publisher was sending it to the wrong subscriber. I had checked this erlier but must have missed the name, we have several subscribers with similar names. After your email, I rechecked and found the error.Greatly appreiate it.HemantThu, 15 Nov 2012 08:19:55 GMTHemant Kordehttp://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxOk, since you are not seeing anything on the subscriber, we need to make sure that you are indeed sending it to the correct subscriber. You will need to expand the publication and right click on the subscription and select Properties. Please verify the Subscriber is the correct server and the Subscription database is correct as well. Check the Status also and let me know what you see.Thu, 15 Nov 2012 08:07:31 GMTDavid Benoithttp://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxThank you for your quick response. I appreciate your help.I looked at the Replication in question. The snapshot Agent is showing that the snapshot was generated (in 4:02 minutes). Aslo, the syncronization status is showing in progress and shoeing transactions being processed. No error anywhere, not even in Replication Monitor which shows status excellent.Thu, 15 Nov 2012 08:02:37 GMTHemant Kordehttp://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxIn SSMS connected to the Publisher, expand Replication, Local Publications, Select the publication you are referring to and expand, right click on the subscription select "View Synchronization Status" and let me know what you see. Also right click on the publication and select "View Snapshot Agent Status" and provide that information. Thanks.Thu, 15 Nov 2012 07:39:33 GMTDavid Benoithttp://www.sqlservercentral.com/Forums/Topic1385102-7-1.aspxNeed Help:I have looked everywhere but I cannot find help for this specific topic. Any help to pinpoint the problem and how to fix it will be highly appreciated:We are running SQL Server 2005. I have created a trans replication on a single subscriber. Both servers are in the same network (no MPLS required for data transfer). When I looked at the snapshot agent, it shows sucessfully completed status. I can also see the snapshot folder. Logreader is running and shows number of articles transferred. Distributor shows it is running sfor over 9 hours since I initially created the replication. However, nothing is getting applied to the subscriber.Can anyone gone through the same problem, list out what I need to check and how to fix this problem. I am unable to find exact answer anywhere on the internet.Thanks.HKThu, 15 Nov 2012 05:34:13 GMTHemant Korde