Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2007-05-18 : 15:18:47
|
| I am in the process of migrating one of our SQL server 2000 to a new server. I copied all the system database files and user data base files to the the new server and started the server.The new server name is different. I updated the column originatingserver in table sysjobs, I have question on following:1. I cannot drop the old server, it says the server has publications2. How do I change the server name in all dts packages? which system table in msdb? (We have about 200 packages)3. The old server is a distributor and publisher. How do I change the name to new server name?Thanks in advance,Rushdi |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-18 : 16:40:46
|
| 1. you may need cleanup replication manually.2. no easy way, have to change it one by one.3. reset replication. |
 |
|
|
rushdib
Yak Posting Veteran
93 Posts |
Posted - 2007-05-18 : 17:07:02
|
| Ok, guys, the management decided to keep the server name same. This makes life easier. |
|
|
|
|
|
|
Server name change and dts pckages, replication