SQL Server Clustering
Is it possible for both nodes in a SQL Server cluster to open up the same .MDF & .LDF file on the shared array simultaneously?
Question 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. AnswerNo, this is not possible. Microsoft clustering technology uses [...]
How do I restore a Master Database in a SQL Server 7.0 or 2000 clustering environment?
This is especially important in a disaster scenario where the Master database is corrupt and you need to restore from a previous backup of the Master database. To restore a Master database, the server has to be started in the single user mode, and that’s where the problem comes in, since Cluster Administrator is the only place [...]


