Greetings All (sorry I havent been around for a while, was visiting the land of Oracle, which was very bleak :-))
Yesterday I did some (SQL2000) repair work on a snapshot replication (deleted and resetup), and its 3 pushed subscribers (NB: the 3 subscribers are used in a load ballanced public web-site).
I was confused about the schedules of the subscriptions, so i set them in three different ways !
(Given that the publication makes a new snapshot every hour) the subscriptions are set to ...
#1 is set to continuous
#2 is set to update every 10 mins
#3 is set to update every hour.
This morning they all seem to work ok, but I want to 'tune', to set most efficiently. I did notice #1 disapeared for a while (IE: the table on subscriber #1 that I query to verify replication-age was empty).
My confusion is - whats the point of pushing a subscription every 10 min's (#2), when the data is only updated every hour? (Every 10 mins was the original, old setting).
Secondly 'continuous' !! (#1) does that mean the last snapshot is continously pushed to the subscriber? (pointless again, if the snapshot is only refreshed every hour) or (since the job schedule confusingly says 'start when sql starts') does this mean run as controlled by the distributer (thats published/distributer - BTW), when theres new data hopefully?
Sorry for lack of word skills (above), brain overloaded with massive amounts of oracle documentation ;-).