Introduction
Database mirroring is used to increase the availability of a SQL Server database and also to increase the data protection. In this process two copies of database is created which are resides on two different servers. So when data is lost at the time of system failure the copied data can be used. To create connection string with database mirroring in SQL server native client 10.0 ODBC Driver provider we need to put provider, your server address, your mirror server address, your database name, set the state of Integrated security to true.
Syntax
Driver={SQL Server Native Client 10.0};Server=urServerAddress;Failover_Partner=urMirrorServerAddress;Database=urDataBase;Trusted_Connection=yes;
|
Further Readings
You may also want to read these related articles :
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here