pawana.paul (10/20/2014)
I have question related to this topic.I want to have 2 node cluster. Node 1 will have instanceA, Database ABC, Node 2 will have instanceB, Database ABC. Can I configure database mirroring between ABC database of instanceA and instanceB?
If all you want to do is use database mirroring you do not need a Windows Server Failover Cluster.
pawana.paul (10/20/2014)
I want to provide instance level and database level redundency (like few of the features of AlwaysON).
Database mirroring provides only database level redundancy. You would need to implement a Failover Cluster Instance of sql server to provide instance level redundancy.
pawana.paul (10/20/2014)
The reason is to use standard edition.
Supports a 2 node Failover Cluster instance
Supports only synchronous replication for database mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉