Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Snapshot Agent in Transactional Replication Expand / Collapse
Author
Message
Posted Thursday, June 10, 2010 2:40 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:15 PM
Points: 1,090, Visits: 189
Hi,
What does the snapshot agent do after the initial snapshot is taken in a transactional replication? If the snapshot agent is scheduled to run twice a day, does it just get the snapshot of the changes made to the schema or does it get the snapshot of all the articles published each time it runs? Explanation of how the snapshot agent works in this case will be greatly appreciated.

Thanks,
Beulah Kingsly
Post #935720
Posted Friday, June 11, 2010 2:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
It is same as the initial snapshot.
Schema changes are replicated by transactional replication.
Post #935875
Posted Friday, June 11, 2010 5:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:15 PM
Points: 1,090, Visits: 189
Thanks Suresh. Will only the changes to schema be replicated or will the entire schema be copied over (as in initial snapshot)?
Post #935926
Posted Monday, June 14, 2010 6:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
Snapshot agent replicates entire schema (as in initial snapshot).
Post #936779
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse