InsideDarkWeb.com

Copy SQL Server Maintenance Plan between instances on same server

I have multiple SQL Server 2019 instances on the same server. I’ve created and exported the first instance’s maintenance plan, edited its exported DTSX file to change the instance and plan names to avoid name conflicts, and imported the edited DTSX via SSIS (and DTUTIL) on the same server.

Problem: I see the the both the original and imported plan in SSIS under Stored Packages > MSDB > Maintenance Plans, but NOT under the second instance’s Management > Maintenance Plans list in SSMS.

Database Administrators Asked by Chad Kieffer on November 11, 2021

1 Answers

One Answer

Here you go:

I believe only Windows server can have only one copy of SSIS installed. So even if you have seven instances of SQL on the same box, you'll only have SSIS devoted to one of them. SSIS will work for all them but will initially only be aware of one of them. I think the following link still holds the answer by modifying MsDtsSrvr.ini.xml to make SQL Server SSIS aware: https://www.mssqltips.com/sqlservertip/2061/how-to-manage-ssis-packages-stored-in-multiple-sql-server-database-instances/

Answered by Sting on November 11, 2021

Add your own answers!

Related Questions

SSRS Standalone install license

1  Asked on July 22, 2020 by preben-huybrechts

     

Ask a Question

Get help from others!

© 2021 InsideDarkWeb.com. All rights reserved.