VBBRett
asked on
SQL Server Database mirroring
I have a question about Database Mirroring. If you have a principle server and a mirror server talking to each other and the mirror breaks, at what point does the mirror server become the principle server? In addition, when the mirror breaks between the two servers, can the mirror or secondary server assume the principle role right away or do you have to perform a restore in order to get the principle server to operate as the primary server altogether?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So if the mirror were to break, what happens to the principal role and the mirrored role? Do they switch?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER