Simple SQL Failover Plan? Log shipping? Mirroring?

290 views Asked by At

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! :)

1

There are 1 answers

4
JohnOpincar On BEST ANSWER

Why wouldn't you use mirroring?