Solved

Distribution server migration

Posted on 2008-10-08
7
436 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

740 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