Dear Ekrem

Dear Ekrem
thanx for giving me the link...
so it means that I'll have to run SQL setup each time I want to create an
Instance. what I know is that I'll be using a different instance name for
different instances, but what about Clustername and Sql servername and Ip
address that is going to be used by clients. shall i have to provide this
information same for every instance or what ?
and one more thing for active/active cluster that i want to confirm ie.
after having
installed sql server on 2 nodes, tell me what i'll have to do to create
instances of
databases. shall i have to create the instances on both nodes or just one
node,
because its the datbases contained by instances.
in our scenairo, we are going to have more than one instances, clear me that
shall I
have to install one instance on first node and 2nd instance on 2nd node ? or
just
install both instances on the same node which will be owned by the 2nd node
in time of failover...?
i think that it will be created on first node(both instances) in the
active/active cluster and the other second node will own it when the first
fails, correct me if im wrong...

Regards
--
DBA
.

Relevant Pages

  • Migrating SQL 7.0 active/active to 2005 Multi-Instance
    ... My company is moving to SQL 2005 from an SQL 7.0 active/active cluster. ... In the SQL 7 active/active cluster, referencing ... data sources required only referring to the server name (ex. ...
    (microsoft.public.sqlserver.clustering)
  • 2 active instances on 2 nodes at the same time SQL 2k5 Standard
    ... active/standby cluster on the standard version. ... I've set up many clustered SQL servers on SQL 2000 Standards a few years ago ... I know I can only run 2 nodes in SQL 2k5 Standard. ...
    (microsoft.public.sqlserver.clustering)
  • Re: backing up to a share from an sql 2000 cluster
    ... Andrew J. Kelly SQL MVP ... "Shaun Buckley" wrote in message ... > 2000 active/active cluster. ...
    (microsoft.public.sqlserver.clustering)
  • backing up to a share from an sql 2000 cluster
    ... Does any know a way of backing up to a share from an sql ... 2000 active/active cluster. ... for stand alone installtions of sql 2000, ...
    (microsoft.public.sqlserver.clustering)
  • Re: SMS Installer Bug?
    ... The box i'm refering too is the one labeled "Name of Computer running SQL ... 2000" Which i counted and only allows 15 characters. ... Andrew Cummings ... allow me to type our complete SQL servername. ...
    (microsoft.public.sms.installer)