Problem With Cluster !!!! -- sql server clustering

DImos GRIZANO-TRIKALWN
9/23/2004 12:59:05 AM

Hello to everyone

I have two dell Poweredge 2650 units and a 6 Shared Hard drives with format
RAID -5 . The two units are clustered together via windows clustering
services. Software called PowerSun on each machines along with the cluster
owner tells which has ownership of the SAN.

What I need:

2 clustered machines, 1 shared storage. I will install my application on
both machines and have the database( or actual application, whichever works )
contained on the shared storeage. When one machines goes down, I want the
other machine to automatically start the application up. IS THIS
POSSIBLE??????

This is very important to me, and would really appreciate any help that is
given.

Dimos-T

Mike Epprecht (SQL MVP)
9/23/2004 2:45:28 AM

Hi

When you install SQL 2000 Enterprize Edition on a cluster, it sets up that
automatically for itself.

If you want your application be be started, make sure that you application
is "cluster aware" (look on MSDN and TechNet for information on that).

SQL BOL and Windows BOL have a lot of information on clustering.

Regards
Mike

[quoted text, click to view]

Jago
9/23/2004 1:09:04 PM

Hi Dimos_m,

Please note it's recommended not to put your SQL data and log files on the
shared quorum disk so you should have a seperate shared disk as the SQL
server disk resource to located the data and log files (even better is to
have two to give data and log a seperate disk each).

Regards,

Jago

[quoted text, click to view]

Greg D. Moore (Strider)
9/24/2004 1:04:51 AM

[quoted text, click to view]

It's not 100% necessary that your app be cluster aware, but it can aid some
things.

We have a clustered pair of servers, one of which runs an FTP server (not
IIS).

When the cluster failovers over, it cleanly starts up on the new machine.

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 : Problem With Cluster !!!!