SQL Server Performance

Removing an article from publication

Discussion in 'SQL Server 2005 Replication' started by satya.sqldba, Jul 22, 2009.

  1. satya.sqldba New Member

    Hello
    I have a publication that is having 10 tables in replication. One of the tables needs a datatype changed in a column. So the table is being removed from the publication by un-checking it form the list of articles. Now after changing the data type comes my question of how to put that back into replication?
    If I put that back into the same publication, do I have to run the snapshot agent for the subscription to pick this article up or would running the log reader agent suffice? I know that if I run the snapshot agent it will take a long time to generate a new snapshot of all the 10 articles. So was wondering if the log reader agent can just pick up the newly added table or is there any other way the subscription will pick this article up with less overhead?
    Thanks
    Satya
  2. MohammedU New Member

Share This Page