• stop all activity on the publisher - kick all your users off. Drop the subscriber and then do a no sync push. You won't need to regenerate the snapshot and deploy it.

    If you can't kick all your users off use the continue on data consistency errors profile.

    --

    Hilary Cotter

    Looking for a SQL Server replication book?

    http://www.nwsu.com/0974973602.html

     
    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com