We have a SP2010 enterprise farm. Currently it is using SQL2008R2 with clustering and we planned to add DR on the farm. Due to some technical restriction, we cannot move the 2nd sql server to DR datacenter and keep the clustering.
So we decide to remove clustering and use mirroring instead. We do not have budget for additional witness server.
I have went though this Microsoft article Configure availability by using SQL Server database mirroring (SharePoint Server 2010). It seems SharePoint 2010 is well designed to support mirroring. But I fail to find any reference about mirroring without witness.
Could you please advise what would be the procedure? Without witness can SharePoint aware the primary SQL is down and switch to secondary?