replication 'Initialize with backup' option

Question

Using 'initialize subscription with backup' option,  I do have all the steps involved to make it happen.  Am I correct in assuming that the data in the publishing database involved can be modified by users while I am doing the 'initialize with backup' process.   As I understand, the backup file (full backup and tranlog backup) I do after the publication is set up will contain info such as LSN to tell replication what data change need to be sync'ed to subscription when i finish setting up the subscription.   Can someone confirm this?

 OD

---

Ocean Deep

Answer 1

Here you go. From MS - http://msdn.microsoft.com/en-us/library/ms147834.aspx

Answer 2

Yes if you use the option then after the publication is created it will keep track of the changed  transactions  and you dont need a log back just a full backup/restore  will do once the repl is configured it will apply those transactions to the  subscriber

the way I have done this is :

1. create publication

2. Backup

3. restore

4. create Pull (can do push) from susbcriber

5. add the subscriber on publisher and initialize from backup

You will need to do some housekeeping beforehand like enabling the publication to initialize from backup flag etc

---

Ap