MS SQL Server - SQL 2005 Mirroring Question

Author

SQL 2005 Mirroring Question

TomT

2006-03-30, 8:23 pm

I have a client with an MS Access (2003) application, connected to a SQL
Server 2005 database. There are a number of linked tables – via a dsn-less
connection string, MDAC is 2.8.

I am investigating the possibilities of using Database Mirroring (I know
it’s not fully supported until sp1) in conjunction with this app.

I would like to get some feedback as to how feasible this is.

1. Is mirroring supported by MDAC?

2. If I use the SQL Native client, and connect tables, etc. via a DSN-less
connection string (specifying the mirror system), would the Access
application be able to make the switch if the primary server went down and
the mirror took over?

3. What other considerations might there be?

Thanks for any help with this,

TomT

Steven Cheng[MSFT]

2006-03-31, 3:23 am

Hi Tom,

Welcome to use MSDN Managed Newsgroup Support.

Here are my answers of your questions:
1. Since Database mirroring is the new feature of SQL 2005, it does not
support MDAC right now. A client can use SQL Native Client or ADO.NET as
the data-access provider to connect to the database mirroring session.

2. The data-access provider stores both an initial partner name and a
failover partner name (when it is available). In general, to establish a
connection for a mirrored database, the data-access provider first tries
the initial partner name. If that connection fails, then the data-access
provider tries to connect using the failover partner name, if available. If
that fails, then the initial partner name is retried. The data-access
provider continues to alternate between the servers until it times out.

You may following the article to see how the Client Connections to a
Mirrored Database
http://msdn2.microsoft.com/en-us/library/ms175484(SQL.90).aspx

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

====================
====================
==========

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

====================
====================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

Sponsored Links