The "plan" so far is: SQL 2005 DB mirroring - with a witness so automatic failver can be used. (Reporting will be done from snapshots on the mirror.

However the automatic failover only...

Going back to mirroring... what happens if the Witness fails?

Vmware is an amazing piece of software. Life will never be the same once we get this little beauty installed 🙂

thanks - that has been most useful

  Matt.

Hi,

We haven't actually installed VMware yet - we are just looking at it as part of a disaster recovery proposal.

I know that you are supposed to have the data and...

Thanks for your help guys....

Can you let me know where I might find scripts for moving the users?

The machine will probably have a different name and IP - but once...