Hi,

SQL is cluster-aware, so you install it on shared drive
(quorum), correct?

Then do data files and program files live on that quorum,
or on each node individually?

Thanks

The Quorum drive exists to determine who has arbitration rights on the
cluster. The owner of the quorum drive also owns the cluster virtual
server. SQL exists in a separate resource group in a cluster.

SQL is installed with the binaries on a local disk on eahc host node. The
data files are located on shared storage (preferably NOT the cluster quorum
drive). SQL installation handles all of this so you don't really need to
worry. SQL also has well documented procedures for updating and maintaining
a cluster should you have a node fail completely or partially.

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

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

"KALI" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks Geoff,
"SQL also has well documented procedures for updating and
maintaining a cluster should you have a node fail
completely or partially."

Any suggestion where I can take a look at those? I found
some at: http://www.sql-server-
performance.com/sqlserver2000_clustering_install_part1.asp

But it doesn't talk about failover.

Thanks again

This link will let you download BOL (Books On-Line, the SQL documentation
kit). The instructions are under 'Maintaining a Failover Cluster'.

http://www.microsoft.com/sql/techinf...2000/books.asp


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

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

"Kali" <anonymous (AT) discussions (DOT) microsoft.com> wrote