Scheduling replication

Posted on 2008-11-19
Last Modified: 2012-05-05
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!
Question by:touellette83
    LVL 31

    Expert Comment

    by:James Murrell
    great info at  about half way down explains schedule


    Accepted Solution

    It is exactly what I am looking for... I am not on- site today - will test tomorrow... But question: if I let the subscriber to run continuously - will it eventually pick up the newly created snapshot? Please, advise...

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how the fundamental information of how to create a table.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now