touellette83
asked on
Scheduling replication
I am new to SQL replication& Finally, was able to configure a snapshot replication and it works great, but I can not figure out how to schedule it&
This is what I am doing to start it manually:
1. (On source server); Right-click the publication and choose re-initialize all subscriptions à choose Use a new snapshotà Generate a new snapshot immediately à Mark for Reinitialization..
2. (On subscriber server (other then the source) à right-click on subscription à choose View Synchronization status -à Start
Is there a way to schedule it all with GUI? If not, please point me to a good source/tutorial on how to do it&
Thanks in advance!
This is what I am doing to start it manually:
1. (On source server); Right-click the publication and choose re-initialize all subscriptions à choose Use a new snapshotà Generate a new snapshot immediately à Mark for Reinitialization..
2. (On subscriber server (other then the source) à right-click on subscription à choose View Synchronization status -à Start
Is there a way to schedule it all with GUI? If not, please point me to a good source/tutorial on how to do it&
Thanks in advance!
great info at http://secure.codeproject.com/KB/database/sql2005-replication.aspx about half way down explains schedule
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.