Russ, I've only theorized about SQL Server replication, but it's on my to-do list this month, I swear! What I can tell you is that yes, you can do it. SQL Server BOL (books online) documentation does a good job of steering you in the right direction, and I've also found the information in SQL Server 2000 Administrator's companion from MS Press useful. If you open up the BOL docs, go to the Contents tab and there is a whole section devoted to replication.
As for 5 web servers hitting one database server and another 5 hitting the other, I assume you could do that but I don't see why. If you were running them in a load balanced/failover mode, you'd want to distribute the load evenly between the two, I would think, and that wouldn't necessarily give you a 5:1 ratio. As for the more technical aspects, I'll leave that to someone more seasoned in this area than myself. Sorry I couldn't be of more help, and good luck! Andy > -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Monday, January 17, 2005 4:41 PM > To: CF-Talk > Subject: MS SQL server replication > > We're just wondering here on what to do when we outgrow our > current sql server box. Can SQL server be run in some sort > of load balanced configuration, where the data is somehow > replicated? Lets say we have 10 web servers, 5 of them would > be hitting 1 db server, and 5 of them would be hitting the > other. Is this possible? Any problems with replication/etc? > > > > Russ > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190844 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
