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: Friday, November 21, 2014 1:23 PM
Points: 1,951, Visits: 1,473
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: 2 days ago @ 12:42 PM
Points: 3,388, Visits: 2,021
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: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
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: 2 days ago @ 11:08 AM
Points: 1,262, Visits: 13,557
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 @ 9:53 AM
Points: 568, Visits: 75,496
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 25, 2014 12:21 AM
Points: 1,083, Visits: 594
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