I'm looking for something akin to this type of replication
in SQL 2012
The web page you referenced sites a couple use cases:
1. Improved read performance, because reads are spread out over two servers.
2. Higher availability if maintenance is required or in case of failure at one node.
For improved read performance we chose to go with mirrored disks under IBM i. Since the files exist on 2 disks - more jobs, processors, etc. have simultaneous access. Wouldn't mirrored disk be easier to manage than mirrored DB servers?
Mirrored disks also support higher availability. If one disk fails, the other picks up the load.
-Nathan.