Solved

Distribution server migration

Posted on 2008-10-08
7
425 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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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…
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.
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.

743 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

11 Experts available now in Live!

Get 1:1 Help Now