首页 > 其他 > 详细

The server instance Witness rejected configure request; read its error log file for more information. The reason 1427, and state 31, can be of use for

时间:2014-01-16 00:20:07      阅读:457      评论:0      收藏:0      [点我收藏+]

数据库服务器做了镜像之后,发现有错误信息

The server instance Witness rejected configure request; read its error log file for more information. The reason 1427, and state 31, can be of use for diagnostics by Microsoft. This is a transient error hence retrying the request is likely to succeed. Correct the cause if any and retry.

错误信息可以知道,应该是收不到请求

然后到镜像服务器去查看镜像信息

SELECT DB_NAME(database_id) AS ‘DatabaseName‘
, mirroring_role_desc AS ‘DatabaseRole‘
, mirroring_role_sequence AS ‘FailoverCount‘
, mirroring_partner_instance AS ‘MirroringInstance‘
, mirroring_state_desc AS ‘MirroringState‘
, mirroring_connection_timeout ‘MirroringConnectionTimeoutInSeconds‘
, mirroring_witness_name AS ‘WitnessInstance‘
, mirroring_witness_state_desc AS ‘WitnessState‘
FROM master.sys.database_mirroring
WHERE mirroring_guid IS NOT NULL

发现有些数据库没有证人服务器设置

知道问题后,赶紧恢复

ALTER DATABASE [DatabaseName] SET WITNESS OFF
GO
ALTER DATABASE [DatabaseName]
GO

The server instance Witness rejected configure request; read its error log file for more information. The reason 1427, and state 31, can be of use for

原文:http://www.cnblogs.com/BinZeng/p/3517235.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!