Great

Thanks for your response, nice to have a 'real' example.

Well I have given in to clustering again and changed the windows edition to Datacentre, the costs between standard and datacentre...

Controlled failover in log shipping seems a lot of hassle, definitely prefer clustering!!

Sounds like I will go back to mirroring then, or may just setup as a cluster as I always have done as this seems the easiest option from a...

Yeah,

OK so back to thelog shipping question, with the following 2 scenarios.

Unplanned failure - What happens when you bring the failed server back up ? What happens to...

If

'going to be ddifficult to detach the databases and copy files if the server is blown up, drowned, short circuited or otherwise down'

that happpens I think I...