Solved

SQL 2008 Witness

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SLQ View not updating 10 46
Date conversion in sql server 2012 6 25
SQL Help - 12 37
Slow SQL query 12 17
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now