Hi,
Posted in the SQL mailing list but haven't heard anything, so
figured I would try here.
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288966
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
