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 |
|
vchui
Starting Member
1 Post |
 Posted - 2007-08-20 : 18:54:53
|
| Hello,Our company develops a Centralized Management system for gaming facilities. Our situation is as follows:Centralized Database where we have 1 SQL server and a single database. There are about 30 to 40 remote sites also with a server that are configured to replicate information back to the central site on a nightly basis. Throughout the year the databases at each remote site gather roughly 10GB of data.We were currently thinking of changing the design to have mutliple databases at Central (I.e. One for each remote site). In addition to this we would have multiple servers which would contain 5 to 10 of each of these remote databases. So essentially if we went with 10 databases per server we would need 4 Centralized servers to handle the replication of 40 halls on a nightly basis.Does anybody see any flaws in this or perhaps can anyone suggest a better solution?Any help or suggestions would be greatly appreciated! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:02:52
|
| What kind of replication do you use? |
 |
|
|
|
|
|
Scalability Configuration