Re: Snapshot only with scheme

Mario,
why can't you just add the article at the publisher? Run the snapshot agent
and only the new article will be generated.
As for the large amount of data that has accumulated on the publisher - this
will be in the form of commands in the distribution database waiting to be
replicated. They'll come over first before the new article. If your
transaction retention period has not been set appropriately (and history
retention period) then the commands will be deleted before synchronization,
which is possibly why you are having to reinitialize. If the subscribers
don't require this data, as you mention, then I don't understand how this is
viable - why use replication at all? Perhaps there is a business reason for
this that I'm missing, and if this is the case, then I'd add the articles to
a new publication and use that with an independant distribution agent and
initialize the new articles that way.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)





.

Relevant Pages

  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)
  • RE: problem adding column to replication table using sp_repladdcol
    ... Ideally add the column using sp_repladdcolumn only at the publisher. ... get dropped each time on the subscriber database. ... I tried adding a column to my test replication DB. ... SQL Server is terminating this process. ...
    (microsoft.public.sqlserver.replication)
  • Re: Cant view merge agent properties (trying again)
    ... Distributor and Publisher are the same machine. ... Server was set-up for Replication (on those servers they are named ... If you plan to use SQL Server merge replication with SQL Server CE ... > that you open a Support incident with Microsoft Product Support Services ...
    (microsoft.public.sqlserver.replication)
  • RE: problem adding column to replication table using sp_repladdcol
    ... Is my replication DB the publisher DB? ... get dropped each time on the subscriber database. ... SQL Server is terminating this process. ...
    (microsoft.public.sqlserver.replication)
Loading