sql server replication: Concurrent Snapshot Processing??? -- sql server replication

Concurrent Snapshot Processing???

BATMAN
10/28/2006 2:20:01 PM

sql server replication:

Other than the following constraints on "Concurrent Snapshot Processing", is
there any reason NOT to check the "Concurrent access durning snapshot
generation" option?

Known Constraints:
--Must run log reader agent after snapshot generation
--Primary key or unique constraint must be contained in clust index

Thanks,

Michael

Thanks,

Re: Concurrent Snapshot Processing???

Hilary Cotter
10/29/2006 8:27:52 PM

It takes longer to generate the snapshot. In some cases this makes the
decision to use concurrent snapshots a poor one.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]