I have a WCF service deployed on IIS and using SQL Server 2008 as backend.
My question is: How can I make cluster(load-balance/fail-over) on IIS and on SQL Server and what sort of thing do I need to keep in mind before doing this? (e.g. do I have to move sessions from in memory to SQL server etc.)
Also, how can I make sure that both SQL servers have the mirror data all time and does both SQL servers shares locks (row, page, table) information in real time?
This is my first time on this. Is this called web farming?