Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
snapshot agent question

Answered snapshot agent question

  • Monday, November 12, 2012 3:10 PM
     
     
    Sign In to Vote
    0

    I am not sure i understand the option "schedule the  snapshot agent to run at the following times" ?

    why would i need this option if i can  choose option

    "create a snapshot immediately " ?

    Sami

     

All Replies

  • Monday, November 12, 2012 3:20 PM
    Moderator
     
     
    Sign In to Vote
    0
    A snapshot will lock the tables that are being replicated. Some people run the snapshot at night or during a period of low user activity to minimize locking. This option allows you to defer snapshot creation until a time which works for you.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

     
  • Monday, November 12, 2012 9:29 PM
     
     
    Sign In to Vote
    0
    but dont i need the snapshot only once during the setup of replication to create the initial tables and database objects n populate the tables ..after that the replication takes over ?

    Sami

     
  • Sunday, November 25, 2012 3:56 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi aliyesami,

    The Snapshot Agent creates files containing the publication schema and data that are used to initialize new subscriptions. By default, the Snapshot Agent runs immediately after the publication is created in the New Publication Wizard. Subsequently, the agent runs according to a schedule you specify. Whether the agent creates new snapshot files each time it runs depends on the type of replication and options chosen.

    Snapshots are generated by the Snapshot Agent after a publication is created. They can be generated:

    Immediately. By default, a snapshot for a merge publication is generated immediately after the publication is created in the New Publication Wizard.
    At a scheduled time. Specify a schedule on the Snapshot Agent page of the New Publication Wizard or when using stored procedures or Replication Management Objects (RMO).
    Manually. Run the Snapshot Agent from the command prompt or from SQL Server Management Studio.

    Snapshot Agent (New Publication Wizard): http://msdn.microsoft.com/en-us/library/ms177171.aspx.

    Thanks.

    Maggie Luo
    TechNet Community Support

     
  • Sunday, November 25, 2012 6:58 PM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Yes, you only need it for the initialization process. You will not need to run it again, unless you reinitialize.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941