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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-30 : 09:30:15
|
| Chong writes "I try to setup transactional replication(TR). The environment as below:3 locations: HQ1, Regional Office2, Branch3.- I setup the Publisher and distributor at Branch3. The user at Branch3 can update the publication.- The Regional Office2 SQL Server will subscribe the Publication from Branch3.- At the Regional Office2, I want to publish the database subscribed above to let the HQ1 subscribe.- I face problem. I can't publish the database for TR, because the Primary key is dissapear.OS = W2K Server SP2SQL = SQL2000 SP2Questions:1. How can I recover the lost primary key at Regional Office2 ?2. IS there any other better solution/design ? The reason we need REgional Office because we do not want all the branches replication direct to HQ at the same time.Thanks.Chongchongtl@isomas.com.my" |
|
|
|
|
|
Replication via multi nodes/locations