Hi,
Hope some one can help with exporting a maintance plan from a MS
SQL 2005 database.
The servers are isolated. I need to be able to get a file on a
CD to move the plans from one server to the other.
I have found:
Open SQL Server Management Studio
Select File | Connect Object Explorer
Change the Server Type to Integration Services and connect to
the server
Expand Servername (Integration Services) | Stored Packages |
MSDB | Maintenance Plans
Right Click on the Maintenance Plan and select Export
But this only seems to let you export from/to servers you can
contect at the same time thru SSMS.
I don't see a way to save/export to a file.
Is there a way to export the plan(s) to a file?
Thanks
Rodney
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2954
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
