locked
initialize subscriber from backup RRS feed

  • Question

    1. Set up the Distributer – database and share – one time setup
    2. Set up Publisher on source server - Don’t use either checkbox for snapshot.
    3. Enable the flag under the Publication properties to allow “initialize from backup”.
    4. Disable the distribution cleanup agents. Make a Full backup of the database. Keep a local copy as you'll need it later.
    5. Copy database to other site. Restore database with the same name
    6. Create pull subscription on the destination server. Check status – Replication monitor -> drill down to publisher ,“View details on the subscription on the right to get a status report After it’s done synching up, turn off the “initialize from backup” flag or else the cache it keeps will never shrink. And re-enable the distribution cleanup agents.
    7. TEST IT. Check the tables after synchronization and then check again after new transactions have been sent.

     

    in 4th step

     Keep a local copy of backup as you'll need it later.

    why?

    Thursday, May 19, 2011 5:43 PM

Answers

    in 4th step

     Keep a local copy of backup as you'll need it later.

    why?

    It's not necessary to keep a copy of the backup after your subscriber(s) are already initialized.

    sqlrepl.com
    Thursday, May 19, 2011 7:00 PM
  • Hi,

    I agree with Brandon. Also, if your subscription is expired, you need to a new backup of publication database.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Alex Feng (SQL) Sunday, May 29, 2011 2:48 PM
    • Unmarked as answer by Suri6012 Wednesday, June 1, 2011 11:21 AM
    • Marked as answer by Suri6012 Wednesday, June 1, 2011 11:21 AM
    Wednesday, May 25, 2011 9:35 AM

All replies

    in 4th step

     Keep a local copy of backup as you'll need it later.

    why?

    It's not necessary to keep a copy of the backup after your subscriber(s) are already initialized.

    sqlrepl.com
    Thursday, May 19, 2011 7:00 PM
  • Hi,

    I agree with Brandon. Also, if your subscription is expired, you need to a new backup of publication database.


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Alex Feng (SQL) Sunday, May 29, 2011 2:48 PM
    • Unmarked as answer by Suri6012 Wednesday, June 1, 2011 11:21 AM
    • Marked as answer by Suri6012 Wednesday, June 1, 2011 11:21 AM
    Wednesday, May 25, 2011 9:35 AM