Monday, March 19, 2012

Can the distribution database be moved from once SQL server to another ?

Hello,
We are decommissioning a cluster and moving all the databases to a new
cluster. The issue is, the distribution database. Is it possible to move the
distribution database without dropping the publications and subscriptions ?
If it is possible, please let me know how to do it.
Thanking you in anticipation,
Yoga
The only way it can be done is to stop all log reader agents. Backup up the
master, msdb, and distribution database(s). Install a new server,
decomission the old one, rename the new server the name of the old
distributor, restore the databases, logs and tail with the keep_replication
switch, run sp_replrestart and use the continue on data consistency error
profile.
If you are lucky this should work.
"Yoganarasimha Prasad" <yogakiran@.gmail.com> wrote in message
news:unYHMx3hHHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hello,
> We are decommissioning a cluster and moving all the databases to a new
> cluster. The issue is, the distribution database. Is it possible to move
> the distribution database without dropping the publications and
> subscriptions ? If it is possible, please let me know how to do it.
> Thanking you in anticipation,
> Yoga
>

No comments:

Post a Comment