开发者

Simple SQL Failover Plan? Log shipping? Mirroring?

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 l开发者_开发百科ooking 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! :)


Why wouldn't you use mirroring?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜