The info I've found on the web so far indicate that SQL Server 2008 does not support true load-balancing.
Is this true? I'm not able to find decent documentation on MS' site, so any links would be appreciated.
Also, the differences between Active/Active and Active/Passive.
I presume that you can't have more than one SQL Server instance connect to the same database, right? Cos that would indicate true load-balancing.
So Active/Active is just when you have two separate SQL Server instances accessing two COMPLETELY SEPARATE databases? If one fails, then it just shares the load onto the one remaining instance? This configuration is only actually any use if we have indeed two COMPLETELY SEPARATE databases then?
So in my case, where I have only one db, I have to go for Active/Passive as the High Availability option?
These are fairly basic questions, but I've not been able to find fairly basic answers!
Thanks Duncan