SQL 镜像端点
我们有一个 SQL 2005 数据库服务器，它使用高安全性（同步、无自动故障转移、无见证）镜像来使我们的灾难恢复站点保持某种热备用状态。 那天晚上，我正准备对主要数据库进行一些更改，准备使用它的新版本的应用程序，这时我注意到镜像在上周五我休假时停止了。 SQL日志和系统事件日志似乎表明存在网络问题，但经过三天的绞尽脑汁，绝望中我删除并重新创建了端点，结果发现原则上的端点出现了故障。 在那之前，我的怀疑完全指向远程合作伙伴服务器。
有人有端点失败的经验及其原因吗？ 我仍然无法准确解释发生了什么或为什么。
We have a SQL 2005 database server which uses high safety (synchronous, no automatic failover, no witness) mirroring to keep our disaster recovery site in a sort of warm standby. I was about to make some changes to the principle DB the other night preparatory to a new version of the app which uses it when I noticed that the mirroring had stopped the previous Friday whilst I was on leave. The SQL logs and system event logs seemed to suggest a network issue, but after three days of head scratching, in desperation I dropped and re-created the endpoints and it turned out that the endpoint on the principle had failed. My suspicions had been entirely pointed at the remote partner server until then.
Does anyone have any experience of end points failing and the causes thereof? I am still at a loss to explain exactly what happened or why.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
“端点失败”有点含糊。 您应该检查主要错误日志并查看是否有任何相关消息，例如“端点无法启动”。 如果我大胆猜测的话，我会说某些应用程序占用了镜像侦听端口，从而阻止了它启动。 另一个可能的罪魁祸首是身份验证失败，例如。 帐户密码已更改（对于 Windows 身份验证）或端点证书已过期（对于证书身份验证）。
如果是证书过期问题，我推荐这些有关主题的文章 基于证书的身份验证如何工作 和 替换即将过期的端点证书
'Endpoints failing' is a little bit vague. You should check the principal errorlog and see if there is any pertinent message, like 'endpoint could not start'. If I'd venture a guess I'd say some application took the mirroring listenning port, thus preventing it from starting up. The other likely culprit is authentication failed, eg. the account password was changed (for Windows auth) or the endpoint certificate has expired (for cert auth).
In case it was a certificate expiration issue, I recommend these articles on the topic How does Certificate based Authentication work and Replacing Endpoint Certificates that are near expiration