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

    SSCommitted

    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?

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

     
    Looking for a FAQ on Indexing Services/SQL FTS

    http://www.indexserverfaq.com

     

  • 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

    SSC-Forever

    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