0

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

Keith Barrows
  • 24,802
  • 26
  • 88
  • 134

1 Answers1

0

Why wouldn't you use mirroring?

JohnOpincar
  • 5,620
  • 3
  • 35
  • 38
  • To my understanding the VM DB would be in a non R/W state while mirroring. I could be wrong... – Keith Barrows Feb 11 '11 at 20:42
  • With log shipping, you're expecting the standby to be in a writable state? – JohnOpincar Feb 11 '11 at 22:46
  • Yes, that would be prefered. As I understand it though, it will not be. (Learning the ins and outs here) – Keith Barrows Apr 18 '11 at 21:21
  • We have opted for Synchronous Database Mirroring (High-Safety Mode) for our solution. A lot of the info I was getting was just plain wrong. See http://msdn.microsoft.com/en-us/library/ms179344.aspx for a good explanation of Mirroring and Failover. – Keith Barrows Jun 10 '11 at 15:00