• Hey there,

    Ok where to start. Firstly I think you may be over complicating things for yourself. I'll start by saying what we do and hopefully someone else will be able to help further cause im off on holiday in 10 min.

    We have an a/p (sql 2005). The san is mirrored to our scf san (but we have found that unpresenting, re-presenting lun's is time consuming and tricky). Our scf is the other side of the city, i am assuming you dr cluster is in the same location?

    Basically we mirror all the databases to the scf sql server and have ssis packages to handle logins, jobs and that stuff (time consuming to set up but after it just runs).

    In a dr test you can manually failover the mirrs. In a real dr you just remove the endpoints and restore the mirrored db's with recovery. Job done.

    In your case with a dr cluster you have a failover for you dr as well.

    One thought though, if your in the same network you could have a 3 node cluster with the third node being your dr node (if you loose both prode nodes the dr come into play), obviously here the san LUN becomes a spof.

    Its entirly upto you, but i think our way is simpler, easier to test and maintain.

    Hope this helps, seeya im off.

    🙂

    Adam Zacks-------------------------------------------Be Nice, Or Leave