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 |
|
Margaret
Starting Member
4 Posts |
 Posted - 2002-10-24 : 10:05:18
|
| We have a sql server 2000 enviroment. Three servers around the world(one in europe and two in the states). We would like to Distribute one database to the other two servers. The database is a batch loading and we have several large tables. The problem with replicating is that some of the tables that we need to replicate are very large and can be completely rebuilt at any given time. Also, we need the constraints on the other two databases, we plan to allow some tables to be updated in europe. We have heard of issues with replicating in this type of enviroment. The log shipping option may have issues with sending large log files to europe. Any ideas on the best approach? |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-10-24 : 11:54:18
|
| Replicating or distributing data is always an interresting issue. Every DBA has to work out the best way of distributing data for his/her DB alone, considering the various options MSSQL offers. Replication, DTS, log shipping... they all have good and bad sides. It all depends on the DB design and business inteligence it covers. I suggest that you pick up a book, compare and then decide what option to take. |
 |
|
|
Margaret
Starting Member
4 Posts |
Posted - 2002-10-24 : 13:22:24
|
| Thank You for your input. Do have any good book suggestions? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-24 : 13:35:25
|
SQL Server Books Online.  It has a very comprehensive section on the various types of replication and the situations for which each type is best suited. It also describes setting up servers for replication and the actual replication process.It's best that you start there first. Any book on replication will very likely cover the same material, with maybe a few extra case studies, and it's unlikely that it will be dramatically more helpful. You will know more about your situation and requirements than a book will. You may need to test more than one kind of replication before you find the right one, and the only way to BE sure is to test it. |
|
|
|
|
|
|
Around The World Distribution?