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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2008-08-13 : 11:57:07
|
| Hello,We are currently in the process of data migration from EMC Sandisk to 3 Par. We are using SQL Server 2000 machines with the following transactional replication topology: Publisher, Distributor, 3 Subscribers (Push Subscription). We have already successfully migrated the Subscribers. Next we plan to perform data migration of the Distributor Server.When we migrated the Subscribers, we just deleted the subscription before the move and added it back after the data migration. As such, it was almost as if those machines were not subscribers at all.Now that we are about to move the Distributor we are not sure if there is something we need to keep in mind. Our current plan is just to stop the replication agents and then follow the same procedure as we did for the subscribers.Has anyone who performed data migration for the Distribution server have any advice on what to keep in mind during the process?Also, how can I script out the replication information in case something goes wrong and I need to recreate replication?Thanks a lot! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 22:29:20
|
| You can do that if don't change server. |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-08-14 : 09:41:53
|
| Rmiao, could you elaborate on what you said please? I'm a bit unclear.Thank you! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-14 : 21:05:14
|
| >> Our current plan is just to stop the replication agents and then follow the same procedure as we did for the subscribers.If you just replace disk on the server, you can stop sql, move db files then restart. If you need move distributor to another server, that's different story. |
|
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2008-08-21 : 10:09:00
|
| rmiao,Thank you for the clarification. |
|
|
|
shafi.spl
Starting Member
10 Posts |
Posted - 2008-09-01 : 16:52:22
|
| please explain clearly |
|
|
|
|
|
|
Data Migration of Distributor Server