Sync data after recreating subscriber database

• dzaganishvili

  Newbie

  Points: 3

  More actions

  November 7, 2008 at 3:31 pm

  #201295

  Hi All, my very first post here...

  Pls can someone explain me if there's any way to sync databases after recreating subscription.

  The scenario i am using is the following:

  I have pull replication on SS2005 over HTTPS. I had a couple of situations when subscription breaks for some reason and I've deleted/recreated it. In this case it always gets a snapshot and creates all the schemas and data from scratch on a subscriber.

  Ideally i would like to tell subscriber not to recreate DB, but use existing one. Just sync data.

  Can it be done somehow?

  many thanks

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  November 9, 2008 at 5:14 pm

  #896096

  All you have to do is tell the publication NOT to create the schema at the Subscriber.

  Go to the properties of the Publication and set the option not to create the schema at the Subscriber.

  ---

  Kindest Regards,