Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Pull to Push subscription Expand / Collapse
Author
Message
Posted Thursday, January 12, 2006 2:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:47 PM
Points: 9, Visits: 106
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.
Post #250433
Posted Friday, January 13, 2006 3:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 27, 2014 11:32 AM
Points: 278, Visits: 229

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

 

Post #250540
Posted Friday, January 13, 2006 8:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 1:47 PM
Points: 9, Visits: 106
Thanks I'll try that!  Any ideas how long every one needs to be kicked off for a 160 GB database?
Post #250657
Posted Monday, March 4, 2013 9:30 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, November 7, 2014 9:34 AM
Points: 3,989, Visits: 7,171
Did this work? I'm looking at attempting the same thing...

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426584
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse