Hi I am new to ms sql 2005 db clustering before. I would like to know if we can use multiple storage space to have zero work loss. Usually on cluster shared space on RAID or SAN is need. Please help me with this information. Thanx..
RAID means Redundancy, which insure SAN continue working in case of one disk failure. but you should have dual HPA in every server , dual SAN switch to insure NPOF (no single point of failure), one spare disk in SAN enclosure. No need for multiple storage space, but it is better for: Separate LUNs for data, LUNs for log , LUNs for hot backup , and in case of large databases (tempdb in separate LUN)
http://www.windowsservercatalog.com/ is also a good one to study on kind of hardware you need for cluster, as they must be compatible with HCL.