Solved

Distribution server migration

Posted on 2008-10-08
7
427 Views
Last Modified: 2013-11-30
Hi fellow experts,

I have a question for you:

I have a SQL server that is used as a distribution server for all our replications. We have about 100 publishers and at least the same subscribers each with many articles. I want to move/migrate from this server, which is a  2k SQL server on an older box to a newer one with 2k5 SQL server.

Ist there an automated way to do this or do I have to do it manually for each publisher/subscriber?
0
Comment
Question by:Zberteoc
  • 4
  • 3
7 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22669398
is it possible that the new 2005 machine be named the same as the old 2000 machine ?  I am not sure there is a good way to do this, but it would make sense that you could stop all of your agents, backup and restore the dist. db to the new 2005 server, rename the old server to something else, and give the 2005 server the name of the older server.  I would think once everything is restore that the replication would now point to the 2005 machine.  Make sense?
0
 
LVL 26

Author Comment

by:Zberteoc
ID: 22669525
It surely makes sense , the problem is I've never done this and I need to make sure that it will work.

ANother question is if I stop the distibution on the old server for the move purpose what happens with the changes that happen to the publishing databases meanwhile? Will I need to restart the distribution on the new server by pushing a new snapshot for each publisher?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22669735
You may need to reinitialize the publications...which kinda sucks.

Im not a server/hardware guy, so I can't say for sure for the rename.  I would think that it would work though. If you have some extra servers lying around, it might make sense to try to recreate the scenario first.
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 26

Author Comment

by:Zberteoc
ID: 22669921
I just found in Management Studio that if you right click on Replication folder and click on Generate Script it builds a script that pretty much looks like it will create all the distribution detailes if run on a different server but I am not sure. It would be way to simple just like that.

Does anybody know aboiut this?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22730771
Is that what you ended up doing..the server rename?
0
 
LVL 26

Author Comment

by:Zberteoc
ID: 22730811
Not yet, we'll see about this as we haven't actually took the migration step yet. Thanks for your suggestions.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22730830
Very welcome...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now