Snapshot Agent in Transactional Replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Snapshot Agent in Transactional Replication

Snapshot Agent in Transactional Replication

Rate Topic

Display Mode

Topic Options

Author

Message

Beulah Kingsly

Posted Thursday, June 10, 2010 2:40 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, July 30, 2012 8:36 AM
Points: 1,090, Visits: 185

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

Suresh B.

Posted Friday, June 11, 2010 2:37 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 1,075, Visits: 5,119

It is same as the initial snapshot.
Schema changes are replicated by transactional replication.

Post #935875

Beulah Kingsly

Posted Friday, June 11, 2010 5:18 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, July 30, 2012 8:36 AM
Points: 1,090, Visits: 185

Thanks Suresh. Will only the changes to schema be replicated or will the entire schema be copied over (as in initial snapshot)?

Post #935926

Suresh B.

Posted Monday, June 14, 2010 6:34 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 1,075, Visits: 5,119

Snapshot agent replicates entire schema (as in initial snapshot).

Post #936779

« Prev Topic | Next Topic »

Permissions