Transactional Replication - Snapshot is not getting applied to subscriber

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Transactional Replication - Snapshot is not...

Transactional Replication - Snapshot is not getting applied to subscriber

Rate Topic

Display Mode

Topic Options

Author

Message

Hemant Korde

Posted Thursday, November 15, 2012 5:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 12:05 PM
Points: 6, Visits: 132

Need 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.
HK

Post #1385102

David Benoit

Posted Thursday, November 15, 2012 7:39 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:56 AM
Points: 2,063, Visits: 3,441

In 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.

David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #1385161

Hemant Korde

Posted Thursday, November 15, 2012 8:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 12:05 PM
Points: 6, Visits: 132

Thank 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.

Post #1385175

David Benoit

Posted Thursday, November 15, 2012 8:07 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:56 AM
Points: 2,063, Visits: 3,441

Ok, 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.

David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #1385178

Hemant Korde

Posted Thursday, November 15, 2012 8:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 12:05 PM
Points: 6, Visits: 132

David, 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.

Hemant

Post #1385193

David Benoit

Posted Thursday, November 15, 2012 8:30 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 7:56 AM
Points: 2,063, Visits: 3,441

Great. Glad that worked. If that wasn't the issue I was going to be hitting the "stumped" button pretty quickly. :)

David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #1385200

Hemant Korde

Posted Thursday, November 15, 2012 8:07 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 12:05 PM
Points: 6, Visits: 132

dave,

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,
Hemant

Post #1385433

« Prev Topic | Next Topic »

Permissions