Scheduling replication...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Scheduling replication...

Scheduling replication...

Rate Topic

Display Mode

Topic Options

Author

Message

iserebriakov

Posted Wednesday, November 19, 2008 11:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 04, 2010 7:39 AM
Points: 7, Visits: 31

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!

Post #605300

jeffrey yao

Posted Wednesday, November 19, 2008 10:16 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:01 PM
Points: 215, Visits: 609

I have not tested it, but I believe you can schedule the snapshot by scheduling the snapshot agent job (which has a category of "REPL-Snapshot") on the distributor server.

Post #605577

Kendal Van Dyke

Posted Thursday, November 20, 2008 8:17 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 10:23 AM
Points: 361, Visits: 781

All replication agents should have a scheduled job that you can change. Do the following:

1) Run Replication Monitor
2) Navigate to your snapshot publication and highlight it
3) Select the "Agents" tab
4) Right click on the Snapshot Agent job and choose "Properties" to open the job properties window
5) Select "schedules" on the list on the left and modify your schedule as necessary

Kendal Van Dyke
http://kendalvandyke.blogspot.com/

Post #605853

iserebriakov

Posted Thursday, November 20, 2008 4:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 04, 2010 7:39 AM
Points: 7, Visits: 31

I am sorry, I am off-site today - will test it tomorrow morning... Please check if you could with this post in case I have more questions... In any event, thank you very much!!!!!

Post #606175

« Prev Topic | Next Topic »

Permissions