Monday, March 26, 2012

Moving the distribution database to a new server

We have one server that is both the Publisher and Distributer. We need to
move the distributer to a separate server. Does anyone know of a good
article for moving the distributor or the steps involved?
We are doing both merge and transactional replication. We have 450
subscribers now and have seen some locking issues (I was able to resolve
these right now). We have both push and pull subscriptions. Most of our
subscribers only connect once or twice a day. We will be adding 200 users
over the next 6 months. Next year we may be adding 1200 additional users.
Any help would be appreciated.
You have to drop all publications and subscriptions and then rebuild them
after you have migrated to the remote distributor.
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
"andersos" <andersos@.discussions.microsoft.com> wrote in message
news:67AF7017-8B6E-4B1C-8C31-81E35609BC51@.microsoft.com...
> We have one server that is both the Publisher and Distributer. We need to
> move the distributer to a separate server. Does anyone know of a good
> article for moving the distributor or the steps involved?
> We are doing both merge and transactional replication. We have 450
> subscribers now and have seen some locking issues (I was able to resolve
> these right now). We have both push and pull subscriptions. Most of our
> subscribers only connect once or twice a day. We will be adding 200 users
> over the next 6 months. Next year we may be adding 1200 additional users.
> Any help would be appreciated.

No comments:

Post a Comment