"Andrew Neillans" wrote:

> Hi all,
>
> I am in need of some replication advice...
>
> We have the following scenario:
>
> Publisher running SQL Server 2005 with SP1
> Multiple subscribers (at the minute, 10, but there will eventually be
> around 30), running a mixture of SQL Server 2005 Express and SQL
> Server 2005.
>
> Now, I am fairly inexperienced with replication via the web service
> (IIS), and have started looking at this particular project at work
> using replication, and noticed something that does not seem right.
>
> Whenever any schema changes are committed, we are forced to regenerate
> the complete snapshot, and as such, the subscribers are forced to
> download and re-initialise their snapshot.
> Surely this is incorrect? Is there any way of configuring incremental
> snapshot changes?
>
> The big problem we have is that there database is around 200Mb, and we
> have users who pay per MB...
>
> Sorry for lack of information, as I say, I'm fairly new to Server to
> Client replication - I normally only configure Server to Server!
>
> Regards,
>
> Andy Neillans
>