Re: Move from active/passive cluster to active/active

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Edwin,

Thanx for your support! It's become more clear to me now...

Nog 1 vraag ... : )

Hoe verwijder ik een Windows 2003 cluster in z'n geheel. Ik draai (voor
test) een 2-node W2k3/SQL2k5 cluster en deze wil ik dus in z'n geheel
verwijderen.
Wanneer ik op de eerst node 'take offline' kies en vervolgens Evict
Node gaat dit goed, alleen bij de 2de node krijg ik RPC errors
(waarschijnlijk omdat hierop het virtuele cluster ip nog draait..)

Gr,
Hiddo


Edwin vMierlo schreef:

NLB is indeed different then failover clustering, however not really usable
with databases such as SQL.

You need to think of your requirements, and then match it to the right
technology option for SQL

Here are some links for reference:
(some are SQL2000, but still applicable for most part)

Failover Clustering
http://msdn2.microsoft.com/en-gb/library/ms189134.aspx

SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Scaling Out SQL Server with Data Dependent Routing
http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx

Federated SQL Server 2000 Servers
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_4fw3.asp

Federated Database Servers
http://msdn2.microsoft.com/en-us/library/ms190381.aspx

Scaling out SQL 2005
http://msdn2.microsoft.com/en-us/library/aa479364.aspx



HTH,
Rgds,
Edwin.


<hiddo.vanloon@xxxxxxxxx> wrote in message
news:1166450266.512747.218020@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
a Network Load balanced cluster is something then a multi instance
cluster right?!

hiddo.vanloon@xxxxxxxxx schreef:

Hi,

sorry for my lack of knowledge on this issue..

I've installed a Windows 2003 Cluster with SQL 2005. Works like a charm
when i do a failover.

Now i want to make this cluster active/active (multi instance) so no
connection is lost when a node goes down, but can't find any info on
how this need to be done. Can anyone help me out here..?!

Thanx in advance!


.

Relevant Pages

  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... I did test and it did not install the client tools. ... http://www.clusterhelp.com - Cluster Training ... Microsoft SQL Server MVP ... Provide a template on how to read SQL Server 2005 setup log files. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)