InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:12:52 GMT20http://www.sqlservercentral.com/Forums/Topic250433-7-1.aspxDid this work? I'm looking at attempting the same thing...Mon, 04 Mar 2013 21:30:23 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic250433-7-1.aspxThanks I'll try that! Any ideas how long every one needs to be kicked off for a 160 GB database?Fri, 13 Jan 2006 08:36:00 GMTRob Mahaneyhttp://www.sqlservercentral.com/Forums/Topic250433-7-1.aspx<P>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.</P><P>If you can't kick all your users off use the continue on data consistency errors profile.</P><P>-- Hilary CotterLooking for a SQL Server replication book?<A href="http://www.nwsu.com/0974973602.html">http://www.nwsu.com/0974973602.html</A></P><DIV> </DIV><DIV>Looking for a FAQ on Indexing Services/SQL FTS<A href="http://www.indexserverfaq.com">http://www.indexserverfaq.com</A></DIV><P> </P>Fri, 13 Jan 2006 03:59:00 GMTHilary Cotterhttp://www.sqlservercentral.com/Forums/Topic250433-7-1.aspxOK I know I am dreaming <img src='images/emotions/w00t.gif' height='20' width='20' border='0' title='w00t' align='absmiddle'> 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.Thu, 12 Jan 2006 14:36:00 GMTRob Mahaney