Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously?
Is it possible for both nodes in a SQL Server 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.
No, this is not possible. Microsoft clustering technology uses what is called a shared-nothing arrangement, which means that only one node of a cluster can access a shared array at a time.
Other vendors offer the ability, in their clusters, to allow multiple nodes to access the same database on the same shared disk array simultaneously, but not Microsoft. The reason Microsoft uses shared-nothing technology is because it is generally considered faster and more reliable that the alternatives.