I have set my database to mirror without a witness.. (sorry dont have a 3th server for acting as witness)
Now basicly how would failover work if my principal server goes down??
Can I just set my application to start to use the mirror server or is there any other action required before my application can switch over to the mirror server??
And what happends if my principal server comes up again will it copy all the data made at the mirror server back to the principal? or will it overwrite my mirror with the latest data on the principal??
I just want to create a basic failover scheme here.. That if one server goes down the backup server takes over until I restored the main server again.. I'm going pure for redudancy here..