need to alter existing arcticle in publication which has been initialized by snapshot in start of rep

  • Hi my req is to stop the repl and modify the primary and secondary repl table and then need to start the repl...Publication has been initialized by snapshot in starting of repl...

    I have tried to do this by uncheck in publication and alter the table and then recheck the table in publication to include..but the replication didn't start...it says the repl is waiting for initial snapshot of modified article...

    But table is big and i dont want to reinitialize the table coz i know that there has been no modification in data....please advice how can i do this.....

  • If you are running SQL 2005.

    You need to run the snapshot agent any time you make change to the publication.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply