We are looking at implementing a SQL cluster and we want to limit data loss if there is a failure. I realize that using AlwaysOn Availability Groups is a better option, but it is a much more expensive option. I know that Failover Cluster (FC) uses shared storage and so I will have a single point of failure on the storage.
My big question is if one of my servers fails will I have any data loss? Another thing that I would like to know is in a FC can I have Server 1 the master of DB1 and Server 2 master of DB2?