Author: Leathal, Posted: Thu Oct 29, 2009 2:21 pm Post subject: Microsoft SQL redundancy question ---- I am wondering which route to go with respect to building a SQL redundancy setup, should get do it with two boxes clustered and share a iSCSI devices between the cluster or should I stick to the Witness/Mirror setup?
I am not sure if Microsoft has made any changes to their mirror/witness in SQL 2008 server but my experience with 2005 is that it more of a headache to maintain. I have seen all sizes of companies using this method and having to pull it a part with time because it fails to work properly.