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 ««12

Initialize Subscriptions Expand / Collapse
Author
Message
Posted Monday, January 30, 2012 7:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 1,860, Visits: 1,398
Nice question. We've just recently started using replication, so this was just what I needed to perk up my Monday.



Everything is awesome!
Post #1243585
Posted Monday, January 30, 2012 7:28 AM


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: Today @ 10:23 AM
Points: 3,299, Visits: 1,978
Nice question. Thanks Steve!
Post #1243596
Posted Monday, January 30, 2012 8:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks Steve
Post #1243686
Posted Monday, January 30, 2012 9:30 AM
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: Today @ 8:18 AM
Points: 3,909, Visits: 3,636
Nice straightforward question, thanks.
Post #1243720
Posted Monday, January 30, 2012 10:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:41 PM
Points: 1,258, Visits: 13,553
nice!!!!

thanks!!!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1243751
Posted Monday, January 30, 2012 1:10 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 8:32 PM
Points: 568, Visits: 71,379
I don't care for the wording in this question. We have a lot of replication in our enviroment. The question says 'adding a publication' where when you add a publication the parameter @allow_initialize_from_backup needs to be set to True unless this is a peer-to-peer replication (defaults to True). No answer for this parameter to allow the subscription to initialize from backup.

From the answers provided I could see that the quesiton was intended to say 'When adding a new subsciption to a publication that has @allow_initialize_from_backup set to True...'
Post #1243876
Posted Wednesday, February 8, 2012 9:36 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:52 PM
Points: 483, Visits: 244
Great question and wonderful url on the covered topic.

Thanks to Steve & Iulian.
Post #1249152
Posted Thursday, August 2, 2012 7:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:08 AM
Points: 1,079, Visits: 591
poojari045 (1/28/2012)
Interesting question!!


Very interesting


What you don't know won't hurt you but what you know will make you plan to know better
Post #1339172
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse