Hi,

Is it possible for both nodes in a SQL Server 2000 cluster
to open up the same .MDF & .LDF file on the shared array
simultaneously and still be able to perform standard SQL
calls (SELECT, UPDATE & INSERT) without causing
corruption, performance degradation and/or sharing issues.

I understand this is not possible under windows 2000 - is
it possible under windows 2003?

thank you,

Benoit

No. Cluster setup is improved with Windows 2003 Server, but the fundamental
design remains unchanged. Only one host at a time can access a clustered
resource.

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

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

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

Thank you!

Benoit

Hi,

I want to test the clustering environment before implementing the same on
production servers. The resources i have with me are high end ( p4 2G ,
512MB RAM ) personal computers. I can install 2k3 on two systems .. what do
i use for "shared storage".. can i use the shared drive of another desktop
computer on the same network as "shared disk array"... please help me out as
i have to give a presentation regarding the same...

Regards,

Navket Singh Naru
DBA

Hi,

I want to test the clustering environment before implementing the same on
production servers. The resources i have with me are high end ( p4 2G ,
512MB RAM ) personal computers. I can install 2k3 on two systems .. what do
i use for "shared storage".. can i use the shared drive of another desktop
computer on the same network as "shared disk array"... please help me out as
i have to give a presentation regarding the same...

Regards,

Navket Singh Naru
DBA