Simple SQL Failover Plan? Log shipping? Mirroring?

Question

I have a physical Prod DB Server (SQL05) and now a VM DB Server. The idea is if the physical machine goes down, we repoint our router (via NAT) to the VM machine. I am thinking of using Log Shipping to keep the VM DB basically current.

1. Is this the correct way to do it?
2. Should I be looking at another way, mirroring perhaps?
3. We would like the VM DB to be in an usable state at all times (so I think this precludes mirroring)

Any (good) suggestions requested! :)

Answer 1

Why wouldn't you use mirroring?