techmiss
asked on
SQL 2008 Witness
Hi All,
I am checking over a customers databases, they have several hosted set and mirrored with a witness sitting inbetween.
Two questions:
1) How do I view the status of the witness, when I log into the SQL instance of said witness I cannot see any direct information - or is this set up from the principal?
2) When I go onto the mirror all the databases have "mirrored synchronised / restoring" next to them, is this normal? Are they in a state ready for switch over by the witness?
Thanks
I am checking over a customers databases, they have several hosted set and mirrored with a witness sitting inbetween.
Two questions:
1) How do I view the status of the witness, when I log into the SQL instance of said witness I cannot see any direct information - or is this set up from the principal?
2) When I go onto the mirror all the databases have "mirrored synchronised / restoring" next to them, is this normal? Are they in a state ready for switch over by the witness?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER