SAP学习资料文档SQL群集.ppt

安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 安装SQL Server 2000群集 检验安装 是否群集服务已启动 文件/目录已创建 注册表项已经生成 缺省组 手工移动组 群集管理器 基本信息(SQL Server安装) SQL Server 2000安装问题 sqlstp.log 对于安装排错 sqlclstr.log 对于SQL Server 2000群集支持安装排错 sqlsp.log 对于服务包安装排错 后缀一个数字以避免覆盖之前的安装日志(用sql*.log找到所有的文件) 在Windows安装目录下(%WINDIR%) SQLDiag报告 SQL Server错误日志 如何着手 通常首先检查SQL Server 2000 安装日志 InstallShield的背景知识 如果安装日志显示SQL Server服务出错，检查SQL Server错误日志 如果Windows群集服务出错，通常检查 Windows事件日志 群集日志 阅读并解释日志 基本技术及方法 十六进制/十进制数字转换 解释错误号(net helpmsg) Technet, MSDN以及Books Online 灾难恢复场景 成员节点失效 在完好的节点上运行SQL Server 2000安装程序 移除失效的节点(不超过1分钟) 重新建立失效的节点 更换硬件，安装Windows及群集服务等 运行SQL Server 2000安装程序加入重建的节点 安装程序完成所需的配置 仅需数分钟… 修复无需系统当机 谢谢大家 * This is determined by how your application works * The Quorum Resource Each cluster has a special resource known as the quorum resource. A quorum resource can be any resource that does the following: Allows a single node to gain physical control of it and defends the nodes control over it Provides physical storage. In MSCS version 1.0, of the default resource types, only the Physical Disk resource can be a quorum resource. However, your hardware manufacturer may supply other resource types capable of storing the quorum resource. The quorum resource stores log data in the cluster log. This data is maintained by the clustering software. If the nodes in the cluster cannot communicate with each other, only one of them is allowed to continue operating. In this situation, the quorum resource, which can be owned by only one node, is used to determine which node can continue operating. When a cluster node is started, it attempts to take ownership of the quorum resource. If the quorum resource does not already have an owner, the node takes ownership of the quorum resource. In this case, the node has formed a cluster. If, when a node