使用dtutil导入维护计划 [英] Import Maintenance Plan using dtutil

问题描述

您好

我正在尝试将维护计划导入到只安装了SQL引擎的新服务器

I am trying to import maintenances plans to a new server with only SQL engine insalled

dtutil / FILE SSISpackageFile。 dtx / DESTSERVER ....

dtutil /FILE SSISpackageFile.dtx /DESTSERVER ....

抛出此错误

此应用程序需要SQL Server 2016 Standard安装Integration Services或Database Engine，企业，开发人员，商业智能或评估版。要安装组件，请运行SQL Server安装程序并选择组件名称。

This application requires Integration Services or Database Engine to be installed by SQL Server 2016 Standard, Enterprise, Developer, Business Intelligence, or Evaluation Edition. To install a component, run SQL Server Setup and select the component name.

我可以在不安装SSIS组件的情况下使用dtutil吗？

Can I use dtutil without installling SSIS componenent ?

环境：SQL 2016 SE SP2

Env : SQL 2016 SE SP2

祝你好运

推荐答案

维护计划要求SSIS正常运行，因为它本质上是一个SSIS包。

Maintenance plans require SSIS to function, since it is essentially an SSIS package.

即使用dtutil导入维护计划，我认为它们不会起作用没有安装SSIS。

Even after importing maintenance plans with dtutil, I don't think they will function without SSIS installed.

如果您不想安装SSIS，另一个实现数据库维护的选项是使用脚本化解决方案，例如
Ola Hallengren的维护解决方案。这种方法实际上是由许多有经验的DBA使用和推荐的。

If you don't want to install SSIS, another option to achieve database maintenance is with a scripted solution, like Ola Hallengren's maintenance solution. This approach is actually used and recommended by many experienced DBA's.

HTH，

这篇关于使用dtutil导入维护计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！