Thursday, March 22, 2012

Active/Active Clustering - Help!

Hi,
The installation you have in the default instance that
run on the primary node. binaries on C:\ databases on
shared cluster disks.
You have to add a new shared clustered disk to the OS an
then to the cluster, Disk resource.
Then, on secondary Node, Node2, you install a named
instance to the local C:\ (new explicit set of binaries
and executables) and the databases to the new sahred disk.
Now you have to intances, default (node1) and named
(node2) with databases on external disks. Then you
install two Vitual SQL Servers (separate IP addresses)
for each instance. You can add additional named instances
to any other node, if yoy add more disks. With multiple
instances SQL200x also support a local installation on
the local disk of ONE node.
Don't even try this. Maybe in SQL 7 this would work. All this will do with
SQL 2000 is confuse you and break your system.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Sca" <anonymous@.discussions.microsoft.com> wrote in message
news:24db01c4acba$663fac80$a601280a@.phx.gbl...
> Hi,
> The installation you have in the default instance that
> run on the primary node. binaries on C:\ databases on
> shared cluster disks.
> You have to add a new shared clustered disk to the OS an
> then to the cluster, Disk resource.
> Then, on secondary Node, Node2, you install a named
> instance to the local C:\ (new explicit set of binaries
> and executables) and the databases to the new sahred disk.
> Now you have to intances, default (node1) and named
> (node2) with databases on external disks. Then you
> install two Vitual SQL Servers (separate IP addresses)
> for each instance. You can add additional named instances
> to any other node, if yoy add more disks. With multiple
> instances SQL200x also support a local installation on
> the local disk of ONE node.

No comments:

Post a Comment