Hello All !
I have some questions about replication with SQL Server 2008 --> context
An offshore team has developped a Web application (IIS 7/.Net 3.5). The databases are stored on volumes hosted on a SAN (Windows 2008 cluster 2 nodes with SQL 2008 SP1 in A/P mode)
Special queries and results (insert/update/delete) are stored in database on cluster
Special consultation queries (select only) are redirected to another server which will contain the database copy) in order to create realtime reports
Log shipping and mirroring can't be choosed because this application needs real time.
I want to know if it is possible to create a solution with cluster and replication. If yes, waht is the prerequisites and how to do that ?
Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
View Complete Post