Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
 Posted - 2006-05-17 : 12:54:33
|
| Hi All,I'm doing a Transactional Replication. For testing purposes I added 1 tableIn that I scheduled the Publishing schedule to be Occurs Everyday 1 day(s), every 30 minutes between 7.45AM and 6.00 PM(ie in every 30 minutes)Subscription schedule to be Occurs Everyday 1 day(s), every 30 minutes between 7.50AM and 6.05 PM(ie in every 30 minutes, 5 minutes after the Publish is run)When I do some change tothe records of Published Table (insert / Update / Delete) , within about 10 SECONDS, it is replicated in the Subscriber table.It does happen regardless of the time I do the change. (Means 12.45, 12.48, 12.52, 12.59 ...)My Question is:What should I do to Replicate, at the scheduled time ONLY ?Srinika |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-18 : 10:48:48
|
| did you create the publication to immediately reflect or run based on the scheduleor you can try to change the replication job schedules instead--------------------keeping it simple... |
 |
|
|
|
|
|
Transactional Replication Schedule doesn't work