I have just watched a tutorial about it on the web and listened. The setup seems ok, i am testing it now and I am comfortable setting it up.

The only...

Thanks for your advice. Which one of you is correct, one says that isnt how it starts and the other says it is??

I am waiting for my colleague to purchase...

Double post sorry.

Just 1 database.

I know restoring it isn't how mirroring works. I meant to restore it so all have the same instance then configure the mirroring within the management studio.

We...

Would the best way to install SQL on 3 machines then backup the DB on the 1st server, then restore the DB to the other 2 machines so they all...

Reading through the MS notes, it is saying Automatic failover requires 3 individual servers, principal, mirror and witness. Is this true, as we have only purchased 2 servers.

Can it be...

Thanks, I will take a look.

Will database mirroring allow automatic fail over to the mirrored DB?