How to Use Database Mirroring in OLE DB Provider
This article explains the connection string used to create database mirroring in OLE DB Provider.
The process of copying data from one location to another storage device in real-time is known as Database mirroring. It is useful in recovery of data after disaster. To create connection string with database mirroring in SQL server native client 10.0 OLE DB 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:
Provider=SQLNCLI10;Data Source=urServerAddress;Failover Partner=urMirrorServerAddress;Initial Catalog=urDataBase;Integrated Security=True;
|
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here