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 |
|
jrsalmeida
Starting Member
2 Posts |
 Posted - 2006-03-19 : 20:39:16
|
| I need to make a sync between 3 or more SQL Servers. We have 3 Small Business server with sql server 2000. In all the 3 locations, branch and headquarters we've the same databate data.For sync with 2 there's no problem. I need to make it with three and then at the end of the year with four.Can anyone help me?CheersJoão Almeida |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-20 : 05:32:48
|
| Read about the Replication in Books OnLine |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-03 : 03:10:08
|
| you need to have a master server that will collect and manage all data coming from the other "child" serversso you'll have master being updated by respective records from child and any change on master gets reflected on childHTH--------------------keeping it simple... |
|
|
|
|
|
|
3 sql server 2000 sync