Pull to Push subscription

• Rob Mahaney

  SSC Veteran

  Points: 268

  January 12, 2006 at 2:36 pm

  #89227

  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

  January 13, 2006 at 3:59 am

  #614567

  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

  January 13, 2006 at 8:36 am

  #614663

  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

  March 4, 2013 at 9:30 pm

  #1593272

  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