Transactional replication SQL Server 2008 From backup Intialization

• AK1516

  SSCrazy

  Points: 2705

  More actions

  January 5, 2012 at 10:12 am

  #250856

  Folks,

  Did anyone have good post for the Transactional replication SQL Server 2008 From backup Intialization

  - Push subscription Like a step by step document or script or work flow or hints ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  January 5, 2012 at 10:39 am

  #1429199

  http://msdn.microsoft.com/en-us/library/ms147834.aspx

• AK1516

  SSCrazy

  Points: 2705

  More actions

  January 5, 2012 at 12:43 pm

  #1429299

  I have question here...

  After I create the publication and change the property of Initialize from backup to true.

  I will be running the script at the publisher based on the url above to indicating that the bak file i would be using to restore at the Subscriber.

  Once this is done

  At the subscriber In which way Do I need to Proceed for push subscription?

  will i need to use script or can I use the Wizard in regular way subscription is setup

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  January 5, 2012 at 12:52 pm

  #1429306

  Push seems to be the default. The optional settings under #6 show a pull sub.

  sp_addsubscription has a default of push: http://msdn.microsoft.com/en-us/library/ms181702.aspx

• AK1516

  SSCrazy

  Points: 2705

  More actions

  January 5, 2012 at 1:25 pm

  #1429335

  Can this same thing be done using Wizard as I am not that good at programming or wizard configuration

  be different ?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  January 5, 2012 at 1:49 pm

  #1429346

  yes, the wizard can do this

• AK1516

  SSCrazy

  Points: 2705

  More actions

  January 6, 2012 at 9:35 am

  #1429719

  Thanks a lot! this really helped...:-)