Microsoft
70-450 · Question #1
You administer a SQL Server 2008 instance. The instance hosts a database configured by using high-safety mirroring operation mode along with a witness server. The witness server is experiencing…
The correct answer is D. Remove the witness server from the mirroring session. See the full explanation below for the reasoning.
Question
You administer a SQL Server 2008 instance. The instance hosts a database configured by using high-safety mirroring operation mode along with a witness server. The witness server is experiencing memory failure and will be offline for four hours. You need to reconfigure the mirroring strategy to minimize the risk of database unavailability. What should you do?
Options
- APause database mirroring.
- BUse asynchronous operating mode.
- CRemove database mirroring.
- DRemove the witness server from the mirroring session.
How the community answered
(36 responses)- A6% (2)
- B3% (1)
- C8% (3)
- D83% (30)
Community Discussion
No community discussion yet for this question.