Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Distribution server migration

Posted on 2008-10-08
7
Medium Priority
?
451 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 1500 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 27

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 27

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 27

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

581 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