Then you are looking at either database mirroring, log shipping or a 3rd party app that can do what you need. If your storage sub-system can handle the replication you may be able to have a geo-cluster that can do what you need.

In all of these scenarios though you will need to have an accepted outage everytime you need to fail the primary over to the secondary and vise-versa.