Use of database mirroring in ODBC driver

In this article I am going to explain about how to create connection string with database mirroring in SQL server native client 10.0 ODBC Driver.
  • 2150

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.