Solved

SQL 2008 Witness

Posted on 2011-09-22
2
249 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

831 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