Changing cluster configuration

My current cluster configuration is Active/Passive, I'm exploring a change to
Active/Active, but I haven't been able to find any informaon on how to do
this, has anyone ever done this? My reason for considering this is the size
of the current server, and the need to bringup other applications on the
seconday node.
Active/Passive and Active/Active are old terms. What you want to build is a
multi-instance cluster. You simply install a new instance of SQL server
with its own disk(s), IP address, and network name. After the installation
you can configure each instance to have preferred owner nodes under normal
conditions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:1EB1CFF5-CACD-41A2-B9ED-06F02A766BC8@.microsoft.com...
> My current cluster configuration is Active/Passive, I'm exploring a change
to
> Active/Active, but I haven't been able to find any informaon on how to do
> this, has anyone ever done this? My reason for considering this is the
size
> of the current server, and the need to bringup other applications on the
> seconday node.
|||Jerrick,
Geoff's answer is dead on!
The only other thing to consider is that there can only be ONE default
instance PER CLUSTER.
The second instance you install will likely be a NAMED INSTANCE.
The virtual server name you choose for your second instance MUST BE UNIQUE,
and the instance name will of course need to be unique as well.
Here are some good resources:
http://www.microsoft.com/technet/pro.../failclus.mspx
and in BOL -
Multiple Instances of SQL Server
Failover Clustering Example - This is very good and I think speaks to your
question perfectly as well.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support

changing a query

This is my current query that I have in an App I wrote:
MySQL = "select DateEntered,Shipper,PickupDate,PUTime,City, State, Zip,
Consignee, Destination, DState, DZip, PickupNumber, ShippersNumber,
PONumber, Consignee_Ref_Number, Weight, Number_Packages, Carrier,
Carrier_Number, Trailer_Number, ApptDate, ApptTime, IDFProNumber,
DeliveredDate, DeliveredTime, FreightCharges, TransitTime, Comments,
LastUpdate, lastcomment from IntermodalTracingMasterFile where " &
tmpMyShippers & " Order by [" & strSort & "] desc "
This works fine.
I need to modify it a little I need to have one query that will return when
the DeliveredDate is empty
and anohter query to return the ones that have somethign in the
DeliveredDate field.
Thanks> the DeliveredDate is empty
If by 'empty' you mean NULL, you can add the following to your WHERE clause:
AND DeliveredDate IS NULL
For non-null values:
AND DeliveredDate IS NOT NULL
--
Hope this helps.
Dan Guzman
SQL Server MVP
"johnfli" <john@.here.com> wrote in message
news:us241LQzEHA.2196@.TK2MSFTNGP14.phx.gbl...
> This is my current query that I have in an App I wrote:
> MySQL = "select DateEntered,Shipper,PickupDate,PUTime,City, State, Zip,
> Consignee, Destination, DState, DZip, PickupNumber, ShippersNumber,
> PONumber, Consignee_Ref_Number, Weight, Number_Packages, Carrier,
> Carrier_Number, Trailer_Number, ApptDate, ApptTime, IDFProNumber,
> DeliveredDate, DeliveredTime, FreightCharges, TransitTime, Comments,
> LastUpdate, lastcomment from IntermodalTracingMasterFile where " &
> tmpMyShippers & " Order by [" & strSort & "] desc "
>
> This works fine.
> I need to modify it a little I need to have one query that will return
> when
> the DeliveredDate is empty
> and anohter query to return the ones that have somethign in the
> DeliveredDate field.
>
> Thanks
>