No the steps are.
1) create your publication on server a.
2) change the identity increment on the publisher to 2. Then using dbcc
checkident make sure that the current identity values are all odd.
3) backup the database, and restore it on your subscriber.
4) Then using dbcc checkident make sure that the current identity values are
all even.
5) create the publication on server b.
6) create your subscriptions using sp_addsubscription, set
sp_addsubscription to true, and do a no-sync.
7) create the replication stored procedures and run them on server a and
server b. use sp_scriptpublicationcustomprocs
to create them.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com [quoted text, click to view] "Bob Groger" <bobgroger@hotmail.com> wrote in message
news:eEcXi8q0GHA.4128@TK2MSFTNGP05.phx.gbl...
> Hello,
> I am trying to set up a test of bi-directional replication using a copy of
> our LOB database. I have dealt with the Identity issues using "not for
> replication" and a seed of 1 on server A and 1000000 on server B. My SQL
> experience level is pretty much limited to clicking things in EM. I have
> successfully got replication to work from server A to server B. My first
> question is that setting up replication from A to B creates a LOT of
> system stored procedures. When I try to set up the other direction more
> system SP's are created on server B. At that time do I need to take a
> snapshot of server B and apply it to server A? If so will that overwrite
> the Identity columns I have already set up? I have Hilary's book and the
> KB article on this but the step-by-step process seems undocumented, at
> least at a level I can understand. Also, is loopback detection on by
> default or must it be enabled?
>
> Thanks!
>
> Bob Groger
>
