November 11, 2007 at 6:55 pm
I manage to create a snapshot replication in 1 of our database which has 35 subscribers. The snapshot replication has an article (compose of 1 table to be sync to the 35 other databases). THe replication is successful the data added in the publisher is updated to the 35 subscribers the subscribers agent is set to "Automatically run when SQL Server Agent Starts". My understanding with this is that the subscribers agent will only starts when the publisher's agnet start right?? after 2-4 days i noticed that 2 databases starts to be unsync and the message with this 2 databases is "THe subscription has expired and must be reinitialized at the publisher"
My questions are:
1. if databases is not in sync why only 2 out of 35 databases??
2. By selecting "Automatically run when SQL Server Agent" the subscriber's agent will not run not unless i will start the publisher's agent but i didn't why does this 2 databases produced an error???
"-=Still Learning=-"
Lester Policarpio
November 12, 2007 at 2:58 pm
I'm not totally clear about your problem. But could you explain why you are using snapshot, rather than transactional replication? What was the rationale behind it?
November 12, 2007 at 5:38 pm
The publisher has a table called holiday table which is the list of declared national holiday and it must be sync with the branch databases (Bank). I used snapshot replication because the table in the database that needs to be in sync with the branch databases are seldom changed because holidays in a year are almost the same compare to the holiday last year.
"-=Still Learning=-"
Lester Policarpio
November 13, 2007 at 8:13 am
http://technet.microsoft.com/en-us/library/ms151188.aspx
That is the link to the lowdown on how and why and when things expire in Replication and worth reading; however, I am not sure how expireration times come into play using snapshot - just merge and transactional. Are you sure you have good connectivity? Stupid question but it needs to be ruled out.
November 13, 2007 at 5:45 pm
First of all thanks for the link that you gave me ill browse to see if there are informations in there regarding my problem. As to our connectivity yes its ok im just wandering if there were timeouts why only 2 out of the 35 databases expires. Another thing that i didn't mentioned (because i forgot to tell) is that prior to my problem 2 of the subscribers also had these issue (other than the 2 subscribers) all i did is to restart the publisher and the 2 subscribers having the problem became sync again but in the case of this 2 other subscribers restart is not the solution. If your thinking "you can re establish the replication" yes i can im just curious as to how it happened..
"-=Still Learning=-"
Lester Policarpio
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply