How to make RDPM SQL Redundant / add a DB copy

Hi,

we are using rdpm enterprise since 2009.
It has become such an important tool for us that we can´t afford downtime, none.
Not that we had any in all those years :).
There are several DB dumps and different methods of backup performed daily to tape, nas and my local machine.
As rdpm gets more functions (credentials, documents, serials, ect...) it also becomes more critical for our business.
So we need more security and we want to add a second (live) database copy on a new vm running on another cluster in another building.

Our database is running on a server 2008 vm with sql express 2008. The one I setup when first trying out rdpm and its still the same.
We have prepared a new vm with sql server 2012 express.

I asked one of our db guys what options there are to make a db redundant. (I´m no db guy myself, thank god :))
But before we progress any further I wanted to ask if there are best practices / recommendations how to accomplish such a setup.

What we want is a copy of our live rdpm database on another server. (1 day lagged copy could make sense)
In case that the main machine fails for whatever reason and to avoid waiting for the restore to complete we want to able to switch our rdpm clients to the second server.
I noticed that there is an option for "Failover Partner" in advanced datasource settings.

Thank you.