ro8inmorgan
asked on
SQL Server 2005 mirroring question..
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..
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..
ASKER
sweet..
and what will happend in case of a short disconnect of the prinicipal??.. how fast will the mirror become the principal server and the principal server the mirror...
And if this works like this without witness then what is the witness server for??
and what will happend in case of a short disconnect of the prinicipal??.. how fast will the mirror become the principal server and the principal server the mirror...
And if this works like this without witness then what is the witness server for??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You don't have to do any actions. You can set your application to start using mirror.
<<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??>>
When Principal server comes up again, it will act as a mirror. It will have all the up todate transactions made on your mirror.