SQL server2005 提供了数据库镜像,一个非常实用的功能。用最节省钱的办法解决了,以前只能用群集才能实现的功能,虽然和群集有很大的区别。对于一般的公司而言,新的这个功能确实很好。不过需要程序的连接串来支持,在以前的每个连接串里面加上一个Failover partner 的参数就可以。
xhtml 代码
复制内容到剪贴板
- <add name="CNNSTR_DB" connectionString="Data Source=db.1589.cn;Failover Partner=mirror.1589.cn;Initial Catalog=DB1589;User Id=1589;Password=1589pass;Pooling=true;MAX Pool Size=256;Min Pool Size=2;Connection Lifetime=30" providerName="System.Data.SqlClient"/>
The syntax of the failover partner keyword is slightly different from one connection method to another:
OLE DB: FailoverPartner (no space between “Failover” and “Partner”)
ODBC: Failover_Partner (underscore between “Failover” and “Partner”)
ADO.NET: Failover Partner (one space between “Failover” and “Partner”)
JDBC: failoverPartner (no space between “failover” and “Partner”)