Replacing a publisher with subscriber

SQL 2000
Currently, I have push transact replication with
immediate updates going out to several subscribers.
I want to take the publisher off the network and have a
subscriber become the publisher...
I will remove replication, and then delete the
field "msrepl_tran_version" from all of the published
tables.
Then I can install replication and push it out to the
subscribers.
I'm not using DRI.
Does this sound like the right plan?
Thanks,
Don
Yes, but what do you mean by "I'm not using DRI?"
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:038601c48edb$fd525570$a401280a@.phx.gbl...
> SQL 2000
> Currently, I have push transact replication with
> immediate updates going out to several subscribers.
> I want to take the publisher off the network and have a
> subscriber become the publisher...
> I will remove replication, and then delete the
> field "msrepl_tran_version" from all of the published
> tables.
> Then I can install replication and push it out to the
> subscribers.
> I'm not using DRI.
> Does this sound like the right plan?
> Thanks,
> Don
>
|||You'd mentioned in an earlier post of mine that if I was
using DRI than certain other steps would have to be done
regarding removing and setting up transact SQL.
Does that sound right?
Don
>--Original Message--
>Yes, but what do you mean by "I'm not using DRI?"
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Don" <anonymous@.discussions.microsoft.com> wrote in
message
>news:038601c48edb$fd525570$a401280a@.phx.gbl...
>
>.
>

rep monitor setup scripts

how to you measure Latency in pull or push sub/publist architecture?
Do you have a set of scripts which use to monitor and setup the
replication environment?
If you are using SQL Server 2005 and transactional replication, please take a
look at the tracer token functionality:
http://www.replicationanswers.com/TracerTokens.asp
If not, please post back with SQL Server version and type of replication.
Rgds,
Paul Ibison
|||On Apr 30, 10:26 am, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> If you are using SQL Server 2005 and transactional replication, please take a
> look at the tracer token functionality:http://www.replicationanswers.com/TracerTokens.asp
> If not, please post back with SQL Server version and type of replication.
> Rgds,
> Paul Ibison
We using sql 2000. please tell me for that
|||Have a look at the counters for these two processes namely the SQL Server
Replication LogReader: Delivery Latency counter and the SQL Server
Replication Dist.: Delivery Latency counter. Also the treplication monitor
reveals similar info
(http://www.informit.com/articles/article.asp?p=170748&rl=1).
Rgds,
Paul Ibison