Hello,
is there any way to export/import maintance tasks from one SQL Server to another ?
We have two SQL Server with same DB. Every day launch a couple of maintance tasks for DB to stay in good state. It will be very helpful to make possible to export/import maintance tasks. I see that maintance tasks are SSIS packages stores in SQL Server. But don't know how to export it.
Any suggestion ?
Thanks
Anton Kalcik
Open SQL Server Management Studio
Select File and then Connect Object Explorer
Change the Server Type to Integration Services, connect to the server
Expand to Servername (Integration Services) | Stored Packages | MSDB | Maintenance Plans
Right click the desired Maintenance Plan and select Export
No comments:
Post a Comment