I need a favour. Currently i have one server with SQL 2008 R2 Enterprise and our applications (Telecom Billing applications).
Application Details : ( All Application are data driven)
Main Databases :
ConfigureDB - 20 GB
All above apps and DB server is running on one server. Now we want to distribute this load to two server with HA. We can distribute our application between two server. For DB server, We want identical databases on both side. We need Active-Active for ConfigureDB, Active-Active (Read Only ons side) for ClientsDB and Active-Passive for all other DB.
1) How can i make Active-Active for ConfigureDB? clustering or Replication?
If we Upgraded to SQL SERVER 2012, How should we get benifit from it in our scenario?
With SQL Server 2012 you could easily scale-out your setup with AlwaysOn.
answered Nov 26, 2012 at 06:49 PM