Sunday, February 12, 2012

Client Application and SQL Mirroring

I have an application where the SQL Database is configured within (I give it
the server name, database name and SQL access info). I did not write the app
and was wondering if it could be used with SQL mirroring high availability
without having to reconfigure the client app.
I skimmed over the link 'SQL Server 2005 Books Online Overview of Database
Mirroring' http://msdn2.microsoft.com/en-us/library/ms189852.aspx and still
am not clear about how the client application sees the mirrored database on a
failure when using the top level mirroring feature - High Availability.
Thanks
New2SQLHi
From www.connectionstrings.com
/*
If you connect with ADO.NET or the SQL Native Client to a database that is
being mirrored, your application can take advantage of the drivers ability
to automatically redirect connections when a database mirroring failover
occurs. You must specify the initial principal server and database in the
connection string and the failover partner server.
Data Source=myServerAddress;Failover Partner=myMirrorServer;Initial
Catalog=myDataBase;Integrated Security=True;
*/
"New2SQL" <New2SQL@.discussions.microsoft.com> wrote in message
news:189496E6-29DC-484B-961F-F8E895363558@.microsoft.com...
>I have an application where the SQL Database is configured within (I give
>it
> the server name, database name and SQL access info). I did not write the
> app
> and was wondering if it could be used with SQL mirroring high availability
> without having to reconfigure the client app.
> I skimmed over the link 'SQL Server 2005 Books Online Overview of Database
> Mirroring' http://msdn2.microsoft.com/en-us/library/ms189852.aspx and
> still
> am not clear about how the client application sees the mirrored database
> on a
> failure when using the top level mirroring feature - High Availability.
> Thanks
> New2SQL
>

No comments:

Post a Comment