Re: SQL2005 Mirroring

In order to use automatic failover, the client needs to be running SQL
Native Client or ADO.NET, with both primary and secondary connections
configured.

SAMPLE: "Data Source=A;Failover Partner=B;Initial
Catalog=AdventureWorks;Integrated Security=True;", where A and B are the
primary and secondary instances.

Good paper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

Sincerely,


Anthony Thomas


--

"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23mHI3SulHHA.1624@xxxxxxxxxxxxxxxxxxxxxxx
If you want the app to know where to go when there is a failover, you
would
have to put the mirror into the connect string. I can't remember the
exact
syntax. This way, when the app starts up and doesn't find the primary, it
just goes to the mirror.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Pierluigi" <Pierluigi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FD905602-1617-45A3-8006-098D629E4C37@xxxxxxxxxxxxxxxx
Hi Tom,
your answers are very useful to me.
Thank you very much.
About the "client", that's what I mean:
I use SQL2005 in the way that it is accessed by the server part of a
client/server application. The client part of the application stay on
Workstation and interact with the server part. Now, only the server part
of
the application makes querys to the SQL DB. So, for the purposes of this
question, I consider the server part of the application as the SQL client.
Now the question is: do I need something (hardware or software) in order
that
the server part of the application is able to use the fail-over feature of
SQL mirroring (or is it all trasparent from the application point of
view...)? More generally: all application that makes querys to an SQL2005
DB
can benefit of this kind of fail-over or is there some constraints ?

Thank you again.
Pierluigi

"Tom Moreau" wrote:

See responses embedded:

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Pierluigi" <Pierluigi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:989A38BE-15C9-4462-93F0-9EC184DD7944@xxxxxxxxxxxxxxxx
Hi everybody.
I have been evaluating this feature in order to fail-over between two
server
in two remote site connected through a 1 Gbps link.

Anybody had good experience about it?

Can I mirror a SQL2005 Enterpise Itanium Edition with a SQL2005
Enterprise
on a 32-bit system ?

TM>>> Yes.

Can I do some Kind of fail-over between the primary and the secondary
without the witness ?

TM>>> Yes, but you have to do it manually.

Can I use a PC with Windows2000/XP and SQL2005 Express as witness ?

TM>>> Yes, any SQL edition can be a witness. I'm not sure about
Windows
2000, but WinXP is a valid OS.

Do I have some prerequisite on the SQL2005 client in order to use
fail-over?

TM>>> Not sure what you mean. Is this "client" the witness?

Thank you in advance.

Pierluigi





.

Relevant Pages

  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now successfully installed them. ... Access front end to a SQL database, Excel can be a front end, A word mail merge document could access a SQL database via ODBC. ... We are trying to install the client software. ... We understand that a Northwind training database is available for SQL Server. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: TDS vs. TCP
    ... I start capturing the network traffic between SQL ... Server and the client. ... I don't see any TDS packets but the communication between SQL ... stand-a-lone server and the client, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Stupid Question
    ... My case One server and Internet. ... > can get that from SQL Server, ... In the case you are describing it does seem doing the manipulation within ... Need to get all the orders for a given client for the current week - some ...
    (microsoft.public.sqlserver.programming)
Loading