I have merge replication with publisher and distributor on the same server and about 20 Subscribers all over the country.
We are moving to another building, with new equipment, so Publisher will be on different server. How to make this move easily, without recreating new publication and pushing new subscribers and implementing initial snapshot, because it will destroy my network.
Is there any possibility to do something like attach/detach DB (distibution and source DB), do few steps more, and to have all like it was before.
Must be.
Thanks in advance.
If you are going to change the publisher server name, you will need to remove replication from the old server and reconfigure it on the new server.
There is another way which you can try:
1) Stop SQL Server on your publisher machine (Machine 1)
2) Rename the machine to something else
3) Copy all the database data files and log files from the old publisher machine to a second machine (Machine 2)
4) Install your new machine (Machine 3), give the old publisher server's name to this new machine
5) Install SQL Server on Machine 3 (which has the old publisher server's name). Make sure the installation directory is the same as the old machine. Bring SQL Server to the same service pack level.
6) Ensure any NT users and logins, AD settings on the new machine is the same as the old machine.
7) Stop SQL Server on Machine 3. Copy over the database data and log files from Machine 2.
8) Restart SQL Server on Machine 3.
Now you should be ready to sync the subscriptions.
No comments:
Post a Comment