Pull to Push subscription

  • Rob Mahaney

    SSC Veteran

    Points: 268

    OK I know I am dreaming but does anyone know of a way to switch a transactional subscription from Pull to Push without having to regenerate a snapshot?  We have a 166 GB database that they want to change subscription type and I don't want to pull an all nighter dropping and adding the subscription.

  • Hilary Cotter


    Points: 1861

    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?


    Looking for a FAQ on Indexing Services/SQL FTS



  • Rob Mahaney

    SSC Veteran

    Points: 268

    Thanks I'll try that!  Any ideas how long every one needs to be kicked off for a 160 GB database?

  • MyDoggieJessie


    Points: 44276

    Did this work? I'm looking at attempting the same thing...

    Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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