跨多个节点/群集部署维护计划的最佳方式 [英] Best way to deploy maintenance plans across multiple nodes/clusters

问题描述

您好，

我们目前的环境：

10个域名之间没有信任

10 domains with no trust between them

每个域都有至少1个MSSQL集群

Each domain has atleast 1 MSSQL cluster

每个集群有3,4,6或8个节点

Each cluster has 3,4,6 or 8 nodes

我被指派帮助当前的DBA为即将开展的项目构建新的集群。当前的DBA为每个可用性组设置了大量的维护计划。他使用Intergration Services将维护计划从节点导出和导入
节点。大多数计划都是基本工作（checkdb，备份，重建，收缩，重新组织，更新统计数据等）

I've been assigned to help the current DBA with building new clusters for upcoming projects. The current DBA has tons of maintenance plans setup for each availability group. He uses Intergration Services to export and import maintenance plans from node to node. Most plans are basic jobs (checkdb, backup, rebuild, shrink, reorganize, update stats, etc)

如果我要遵循他的方法，我将不得不导出/导入大约10个计划每组/节点，这导致必须编辑超过100个计划。

If I was to follow his method, I would have to export / import around 10 plans per group/node, which results in having to edit over 100 plans.

对我来说，导出，编辑和导入所有这些维护计划似乎很多工作。我想知道，有更简单的方法吗？

To me it seems like alot of work to export, edit and import all these maintenance plans. I was wondering, is there an easier way to do this ?

推荐答案

嗨Ro_vi，

Hi Ro_vi,

 

>>如果我要遵循他的方法，我将必须导出/导入每组/节点大约10个计划，这导致必须编辑超过100个计划。

>>If I was to follow his method, I would have to export / import around 10 plans per group/node, which results in having to edit over 100 plans.

 

根据您的描述，我认为您似乎对集群sql server配置的维护计划有错误的理解。您不需要为集群sql的每个节点配置相同的维护
计划服务器，只需要配置一次，因为维护计划存储在msdb数据库中e msdb数据库存储在共享磁盘上，可以被主动节点访问。

According to your description, I think you seem to have a wrong understanding of the maintenance plan for the cluster sql server configuration.You do not need to configure the same maintenance plan for each node of the cluster sql server, only need to configure once, because the maintenance plan is stored in the msdb database, the msdb database is stored on the shared disk and can be accessed by the active node.

 

您可以根据以下链接中的步骤使用ssis将此维护计划导入这十个集群sql服务器 ：
将SQL Server维护计划从一个服务器移动到另一个服务器

 

希望这可以帮到你。

最好的问候，

Dedmon Dai

Dedmon Dai

这篇关于跨多个节点/群集部署维护计划的最佳方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！