Solved

SQL 2008 Witness

Posted on 2011-09-22
2
250 Views
Last Modified: 2012-05-12
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
Comment
Question by:techmiss
2 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 500 total points
ID: 36579635
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
 

Author Closing Comment

by:techmiss
ID: 36579713
Usefull query, thanks!
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question