Dear All, 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)
5+ Application Running 24*7
15+ application will run on demmand
Web Site with 100 concurrent user
Main Databases : ConfigureDB - 20 GB
ClientsDB - 90 GB
CDRDB - 1.25 TB (It grows around 40 GB every day. Partitioning already done)
ReportingDB - 800 GB (It grows around 10 GB every day. Partitioning already done)
ApplicationTempDB - 10 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?
2) How can i make Active-Active (Read Only ons side) for ConfigureDB?
3) Active-Passive for CDRDB,ReportingDB? If we Upgraded to SQL SERVER 2012, How should we get benifit from it in our scenario?