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: Yesterday @ 7:35 AM
Points: 1,826, Visits: 1,359
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 @ 6:57 PM
Points: 3,258, Visits: 1,954
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: Yesterday @ 1:54 PM
Points: 3,869, Visits: 3,620
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: Yesterday @ 11:04 AM
Points: 1,254, Visits: 13,552
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 @ 12:08 AM
Points: 568, Visits: 69,632
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: Thursday, June 19, 2014 10:32 AM
Points: 483, Visits: 243
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