How do you get your CF server to look for the database on the mirrored
server? Obviously the two servers cannot have the same IP or name since they
are on the same network.
Give them a subdomain name, then you don't have to do anything, just
update the DNS. That's what we do - the SQL
On Monday 05 Nov 2007, Chad Gray wrote:
I have the book SQL Server 2005 Unleashed. It is saying you have three
servers. You Principal Server, Witness Server and Mirror Server. The
Witness server is what decides when to switch over to the Mirror Server.
And now the Witness server is just as
I am reading up on mirroring our MS SQL server.
What I have read you can setup a second server with a second installation of MS
SQL. The licensing allows for this also so you don't have to buy two copies.
Now you can mirror from one server to the other.
Now my question is say you primary
I do not speak from experience, but I believe you must have special DB
drivers set up with your CF data source which do the fail over for you.
~Brad
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 11:12 AM
To: CF-Talk
Subject: MS SQL
Chad Gray wrote:
I am reading up on mirroring our MS SQL server.
What I have read you can setup a second server with a second installation of
MS SQL. The licensing allows for this also so you don't have to buy two
copies.
Now you can mirror from one server to the other.
There are
kind of flaky.
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 3:14 PM
To: CF-Talk
Subject: Re: MS SQL Mirroring and CF
Chad Gray wrote:
I am reading up on mirroring our MS SQL server.
What I have read you can setup a second
that the database is
mirrored.
I will have to setup a datasource that is mirrored and try it out.
Thanks!
Chad
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Monday, November 05, 2007 1:02 PM
To: CF-Talk
Subject: RE: MS SQL Mirroring and CF
I do not speak from
7 matches
Mail list logo