Experiences with multiple replication setups at the same time

Does anyone have experiences in setting up multiple replicated databases
using peer to peer replication at the same time? I've been attempting to do
so using the GUI and scripting where possible and it seems they always end
in deadlocking of resources. I'm testing this possibility for the obvious
reason of time savings, however it seems that it not possible.
My simple scenario is simply, two servers, five databases.
I begin the scripting of running the 5 scripts for adding articles at the
same time and they are exponentially longer running and always fail with
deadlocking error messages. I have almost 950 articles and this has been
taking about 45 minutes with a simple 2.4GB database.
Adam P. Cassidy
I am confused. Exactly how are you creating your peer to peer publications.
Did you follow this guide?
http://msdn2.microsoft.com/en-us/library/ms152536.aspx
Hilary Cotter
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
"Adam Patrick Cassidy" <apcassidy@.aol.com> wrote in message
news:%23eKbN3HGHHA.1188@.TK2MSFTNGP06.phx.gbl...
> Does anyone have experiences in setting up multiple replicated databases
> using peer to peer replication at the same time? I've been attempting to
> do so using the GUI and scripting where possible and it seems they always
> end in deadlocking of resources. I'm testing this possibility for the
> obvious reason of time savings, however it seems that it not possible.
> My simple scenario is simply, two servers, five databases.
> I begin the scripting of running the 5 scripts for adding articles at the
> same time and they are exponentially longer running and always fail with
> deadlocking error messages. I have almost 950 articles and this has been
> taking about 45 minutes with a simple 2.4GB database.
> Adam P. Cassidy
>
|||Hilary,
Absolutely. I have no problems with creating a peer to peer environment.
What I'm having problems with is running multiple scripts concurrently for
multiple databases at the same time on the same server. Even two at a time
fail. As you are aware, during the creation of a publication for example,
you are offered the opportunity to create a script for the publication.
Well in my testing environment, I have 50 databases that are exactly
identical except for the name. So, when I created the first publication I
scripted it, and then just changed the database name for each of the
remaining 49 with hopes that instead of having to step through graphically
the remaining 49 that I could just run the 49 unique scripts - negative. I
can't even run 2 at a time in my testing, anytime I do I get deadlocks in
both and I have to delete them and restart.
Sorry for any earlier confusion.
Adam
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ePdp6iIGHHA.960@.TK2MSFTNGP04.phx.gbl...
>I am confused. Exactly how are you creating your peer to peer publications.
> Did you follow this guide?
> http://msdn2.microsoft.com/en-us/library/ms152536.aspx
> --
> Hilary Cotter
> 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
>
> "Adam Patrick Cassidy" <apcassidy@.aol.com> wrote in message
> news:%23eKbN3HGHHA.1188@.TK2MSFTNGP06.phx.gbl...
>