Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
techmiss
Asked:
techmiss
1 Solution
 
AnujCommented:
1.To view the status of witness

SELECT mirroring_witness_name, mirroring_witness_state,mirroring_witness_state_desc
FROM sys.database_mirroring

2. This is quite normal behavior, says that the mirror is almost synchronized with the principal server and the changes from principal server is being applied to the mirror. As long as the transaction safety is set to FULL automatic and manual failover is possible and if the transaction Safety is off there is a chance of data loss.

See more on Mirroring states
0
 
techmissAuthor Commented:
Usefull query, thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now