partition? mirror? failover? balance? ...? different purpose has different method. I suggest you clarify the purpose first, and then MSDN and google corresponding method.
好像不行,sql不支持群集。。
http://tech.itdb.cn/n/200607/27/n20060727_30318.shtml
群集要解决的问题好像是高可用性,而非负荷分担,你这个感觉要用分布式查询来做。