October 7, 2009 at 6:24 am
Hi
I have implemented transactional replication between 2 databases.On the target server i see that the replicated table's createdatetime becomes todays date everyday.
Does this replication drop and recreate everytime replication happens?
Is there a way throgh which this can be configured?
If so what will be the effect on the replication?
Thanks
Koustav
October 7, 2009 at 6:35 am
koustav_1982 (10/7/2009)
HiI have implemented transactional replication between 2 databases.On the target server i see that the replicated table's createdatetime becomes todays date everyday.
Does this replication drop and recreate everytime replication happens?
Is there a way throgh which this can be configured?
If so what will be the effect on the replication?
Thanks
Koustav
That is because your Snapshot Agent is running on recurring schedule daily.
Just go to the Snapshot Agent's properties (through Replication Monitor) and change Agent's schedule to One Time instead of Recurring. You may also just disable a schedule at all.
October 7, 2009 at 7:03 am
even though the snapshot agent is running that shouldnt affect the subscription unless you run the reinitialise command.
October 8, 2009 at 11:57 am
how do i stop re-initialize command?
also if i stop snapshot agent schedule, how will the snapshots be generated?if there is a chaqnge in the table how will that be replicated?
October 8, 2009 at 6:27 pm
if there is a chaqnge in the table how will that be replicated?
Changes will be replicated based on the transactional replication schedule that you specified during configuration.
MJ
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply