initialize subscriber from backup

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?

Answer 1

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

Answer 2

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.