Pull to Push subscription
-
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. -
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 -
Thanks I'll try that! Any ideas how long every one needs to be kicked off for a 160 GB database?
-
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