SQL群集配置 [英] SQL cluster configuration

问题描述

大家好，

我们有一个SQL故障转移群集（被动 - 主动），它由两个服务器节点组成，用于保存我们的SharePoint环境的数据库。我遇到了一个问题，有人错误地改变了群集配置设置。它占用了b $ ba ba的大部分时间，但我和我的同事能够放回正确的设置以恢复群集。从那以后，我一直在调查在这种情况下更糟糕的情况下恢复群集的最佳方法。 

We have a SQL fail over cluster(Passive-Active) which consist of two server nodes and is used to hold the DBs for our SharePoint environment.I ran into an issues where someone mistakenly altered the cluster configuration settings.It took the great part of a day but I and a colleague of mine where able to put back the correct settings to bring the cluster back. Since then I have been investigating the best way to recover a cluster in situations like this and worse. 

首先，我可以知道是否有配置文件突出显示所有群集的原始设置？如果是这样，我可以知道它通常位于何处。

Firstly may I know if there is a configuration file that highlights all the clusters original settings? If so, may I know where it is usually located.

其次，您能否明确指出我的文档或解释如何备份群集的配置以及如何恢复它？

Secondly,could you clearly point me to a document or explain how I would backup the configuration for a cluster and how I would restore it?

非常感谢，

Dom

推荐答案

Hi
Dom ，

 

Configuration.ini文件 列出您为SQL Server
<指定的所有设置span lang ="zh-CN">故障转移群集设置 。您可以在路径中找到该文件（例如：SQL Server 2017）"％programfiles％ \ Microsoft SQL Server \ 140'\\ Setupup Bootstrap \ Log \ "默认为
。

 

请参阅文档：
< a href ="https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-2017" > 使用配置文件安装SQL Server

 

最好的问候，

Emily

这篇关于SQL群集配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！