August 1, 2002 at 6:17 am
Hi Guys,
I am using a snapshot replication with not updatable option and also replicate it for 6 PM on each day. Also I make the snapshot agent to run only once.
Now our client wants to replicate the data for every half an hour . Also the deleted/added records in the main server are not replicated into the subscriber .
How can I achieve the above two without delete the publication/subscription ?.
Thanks in advance
Jerish
August 1, 2002 at 8:57 am
Not sure Im clear on what you want to do. Sounds like you want to do transactional but with some special filtering? You'llhave to drop the pub to switch replication modes, you may be able to start with the data already on the subscriber and not do a snapshot depending on what you're trying to accomplish.
Andy
August 1, 2002 at 10:58 pm
Warren,
Below is the one what we want. We are having two servers . The publication server is the main server in which we are maintaining all the business tables [Here we can add/edit/delete records of business tables]. In the subscriber database we need to maintain the data available in the publisher's business table . Publisher's data should be updated to subscriber's database for every 30 minutes.
We have already created a snapshot replication to update the subscriber's database at 6 PM on every day. But we observed that the subscriber's database is updated only once (ie, the first time only). There after it is not getting updated at the specified time. We don't know what is the problem ? .
Please advice
Thanks
Jerish/Ravi
August 2, 2002 at 2:29 am
If you want the data updated every 30 minutes you need to either use snapshot and run it every 30 minutes, or transactional. By default transactional will run continuously and while possible to change that, for simplest administration I recommend you leave it that way.
If your snapshot job isnt running I'd double check the schedule to see if has been disabled.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply