开发者

Simple SQL Failover Plan? Log shipping? Mirroring?

开发者 https://www.devze.com 2023-02-09 20:18 出处:网络
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

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

精彩评论

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