How to Convert from Active/Passive SQL Cluster to Active/Active SQL Cluster -- sql server clustering

Jason
3/30/2004 12:47:02 PM

I would love to know how its done too . I have setup a
Active/Passive on Windows 2003 and SQL 2000. Is there an
article you could link me up with ? Thanks a bunch

[quoted text, click to view]

John S
3/31/2004 7:08:20 AM

I am using Win2k Advanced Server SP4 and MS SQL2000 Server
Enterprise Edition SP3 (8.000.818).
[quoted text, click to view]

Jason
3/31/2004 9:40:40 AM

...The second instance would be a named instance
right ,since I had my first instance a default
instance..Or will the second install also highlight
default ?

[quoted text, click to view]

Geoff N. Hiten
3/31/2004 11:28:30 AM

Adding a second instance is pretty much the same as installing the first
one. You will need yet another IP address and one or more disks to anchor
the SQL group. Run install again, give it a new instance name, fill in the
blanks for the IP and select which disk to use. Note that you cannot use
the same IP, name, disks, or group as the first instance. This will appear
on the network as a completely different SQL server.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

Jason
3/31/2004 11:53:44 AM

Just to be clear, One default instance per cluster. So
when i set up another instance( multiple instance or
active/active ) , is that considered another cluster or
is it the same cluster . If its considered another
cluster , then i can have another default instance per
your statement. Dont want to get too confused :-)

My thinking leads me to believe that multiple instance or
setting up active/active would result in one being
default and the other being named or 2 named instances..
Am i right in my theory ?

[quoted text, click to view]

Geoff N. Hiten
3/31/2004 1:45:56 PM

You can only have one default instance per cluster. Any additional
instances would be named instances.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

Geoff N. Hiten
3/31/2004 3:20:13 PM

Same cluster. Another instance. However, it shows up as a separate server
on the network since it has its own IP address, network name, and disk
resources.

You can have one default and 15 named or 16 named instances of SQL on a
cluster.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

rboyd NO[at]SPAM onlinemicrosoft.com
3/31/2004 4:33:16 PM

To convert from an active/passive to an active/active you will need to add
at least one new physical drive to the cluster. After you do that it is a
matter of installing a new instance of SQL Server 2000 and using that
drive/drives to house the databases.

In an active/active SQL Server cluster each instance of SQL Server must
have its own physical drive. This is documented in SQL Server Books on Line.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Aneil
4/3/2004 8:11:03 AM

You have indicated a physical disk is required to be added. Will adding a new Logical disk not due? The instance can run on this can it not

sanchans NO[at]SPAM online.microsoft.com
4/14/2004 3:22:19 PM

Interesting discussion going on and you guys have it all figured. Just
thought would drop by some useful links that might help you folks to carry
forward your discussion.

SQL Server Failover Clutering
http://www.microsoft.com/SQL/techinfo/administration/2000/failovercluster.as
p

Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218

Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering
http://support.microsoft.com/?kbid=260758

I haven't gone through all the posts, so I might be adding something that
you folks might have already explored. But nonetheless, hope that you will
find them helpful.

Sanchan [MSFT]
sanchans@online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

shankr NO[at]SPAM -NOSPAM-gmail.com
7/14/2004 8:58:01 PM

I tried the steps on my W2K3 server with SQL 2000, but do not get the cluster resources for server 2 to show up in the cluster administrator. So I dont think I have the failover feature even though I do see services for that named instance created on both the machines though. During the installation I got an error popup that it failed to refresh the cluster resources, but it continued and completed after that.

Are there any known issues here. Can I do something manually for them to have the failover feature.

---
Posted using Wimdows.net NntpNews Component -

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : How to Convert from Active/Passive SQL Cluster to Active/Active SQL Cluster