Skip to main content
K
kd6aqm-kQOwxc
Participant
August 7, 2006
Question

SQL2005 Mirroring

  • August 7, 2006
  • 4 replies
  • 1180 views
Does anyone use SQL2005 mirrored with automatic failover?
If so, were would I find additional information on setting this up? I am currently running 2 CF server (using hardware load balancing) and need to set up an automatic failover for the datasource for my 2 mirrored sql2005 servers.
Any help would be appreciated.
-Chuck
This topic has been closed for replies.

4 replies

A
Anonymous
August 30, 2007
However, If kd6aqm's question is about SQL side set up, I found a walk-through of the process of setting up mirroring at:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html#implement

A
Anonymous
September 12, 2007
Chuck,

Have you received an answer to this one? Does anyone have an answer?

If I am using ColdFusion MX 8 and create a datasource, I specify a SQL server. However, there are two servers for a mirrored database, not counting the witness. If I specify the principal server when I create the datasource in CFAdmin, what happens if the Witness switches the principal to the mirrored SQL server? How does CF know what to do? How does it know where the mirrored server is located and how does it know when to switch to the mirrored server?
J
Jim Stout
Inspiring
December 14, 2007
Hello all,

We also are looking at setting up a SQL 2005 Mirror (NOT a cluster) and connecting to it with ColdFusion 8. However, in researching this I came across a troubling statement in " Database Mirroring Best Practices and Performance Considerations" from Microsoft:

"Applications that connect to a database with ADO.NET or the SQL Native Client (SNAC) can automatically redirect connections when the database fails over to the mirror."

What about JDBC connections through ColdFusion? Can they automatically deal with the fail over? Any ideas?

Thanks in advance...

-Jim
A
Anonymous
August 30, 2007
I can't speak for kd6aqm, but my question was on the CF side. I believe I can set up the SQL mirrored DBs. The instructions on that seem to be very clear.

However, for MX 7 there seemed to be special drivers that needed to be installed to properly configure CF to use a mirrored DB. Are you stating that with MX 8 all I do is point the datasource to the DB on the principal SQL server and the failover is automatic to the mirror if the witness so decides?
S
Scott_thornton
Known Participant
August 30, 2007
Yes I use it.

I am migrating my app to a clustered 64bit 2005 sql server this weekend.

What information do you need exactly? SQL side or CF side? You won't have to do anything CF side.

The MSDN site is pretty good for this sort or thing, as well as sqlservercentral.com
A
Anonymous
August 29, 2007
Have you obtained an answer to your question about SQL2005 mirrored with automatic failover? I need the same answer, but for MX 8.

I'm getting ready to move to SQL 2005 with mirroring and will also be moving to ColdFusion MX 8. I would think with MX 8, Adobe/Macromedia would have this working as part of the standard database source setup in Admin, but I can't find anything on it.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices