sql 2000 replication question

Last Post 22 Dec 2006 12:08 PM by PaulMcKibben. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
19 Dec 2006 05:29 PM
I originally set up snapshot replications of some db's from one server to another server because the tables had no keys. We then added keys and changed the replication to transactional replication. The subscriptions are all pull subscriptions.

The issue that I have is that the subscriptions seem to be only occuring Monday morning which is when I had the original snapshot subscriptions set to execute.

Do I need to delete the subscriptions and rebuild them? I have run out of ideas at this point, and any help would be greatly appreciated.

Thank you.
PaulMcKibben
New Member
New Member

--
20 Dec 2006 02:19 PM
Scheduled
PaulMcKibben
New Member
New Member

--
22 Dec 2006 10:40 AM
It is relatively static data that is being replicated and is being replicated nightly. So I have the pull subscription jobs set to execute at approximately 12:30 a.m. Monday - Saturday. The snapshot jobs are scheduled at approximately 12:30 a.m. Tuesday - Saturday, and the LogReader jobs are continously executing.

I am going to schedule the subscriptions also for Sunday.

Any other suggestions would be greatly appreciated.
PaulMcKibben
New Member
New Member

--
22 Dec 2006 12:08 PM
Just did. All are scheduled every day now.

I will see if that resolves the issue. My concern is that I have just moved the original issues to off-hours.
You are not authorized to post a reply.

Acceptable Use Policy