June 14, 2006 at 2:44 am
Hi,
I have transactional replication (push, continuous) in SQL Server 2000.
One of the subscription is not working properly and when I reinitialize it, it works; after 3 hours it stops.
Can any one suggest me to overcome this problem?
R.Prakash.
R
June 16, 2006 at 8:44 am
Are you saying that the snapshot completes successfully but then replication stops after three hours?
If you are saying that, is it exactly three hours every time? Have you checked the agent history for the distribution and log reader agents. Try setting to verbose output if it's not giving enough detail.
If you mean that the execution of the snapshot stops after three hours, it could be due to a foreign key constraint - perhaps the snapshot agent is loading data into a "child" table before it has populated the "parent". You should remove foreign keys before you run the snapshot and recreate them afterwards. Check the snapshot agent history and it should give you a clue as to what is going wrong.
Do publisher and subscriber databases have the exact same schema? Maybe, for example, a column in the publisher has a bigint data type but the corresponding subscriber column is int?
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply