sql server replication: All -

How often do we need to reapply initial snapshots in a
Transactional replication?
How much time does SQL Server takes to apply the initial
snapshot, say if I have a 100 MB, a 500 MB and a 1 GB
database, each separately?

Thanks -

you need to apply them the first time and then each time you make a change
to your publication or when a subscription expires.

The length of time it takes to apply a snapshot is a function of the amount
of data you are sending across the wire, the bandwidth available and its
speed, and the hardware on your publisher and subscriber.

I can do a Gig in under 20 minutes on a 100 mbit lab.

[quoted text, click to view]