January 31, 2007 at 2:26 pm
Hi,
Is there a simple way to copy database maintenance plans from one SQL 2005 server to another ? I know there is no straightforward way to script maintenance plans like the SQL Jobs, but was wondering if there was any other way this could be achieved.
TIA
January 31, 2007 at 7:42 pm
In 2005 MP uses SSIS packages so I think you copy the SSIS package from msdb..sysdtspackages90 table where it is stored.
select
* from msdb..sysdtspackages90 where packagetype =6
The client that created the package. The values are as follows: 0 (default client), 1 (SQL Server Import and Export Wizard), 2 (DTS Designer in SQL Server 2000), 3 (SQL Server Replication), 5 (SSIS Designer), and 6 (Maintenance Plan Designer).
MohammedU
Microsoft SQL Server MVP
February 1, 2007 at 4:47 am
As far I known you can export but it would not work. We tried in many way. One way is to export the job package and schedule it.
February 1, 2007 at 9:15 am
I tried copying the packages from source but when I try to make any changes and save at the destination I get the following error :
GUID should contain 32 characters with 4 dashes
and the changes are not saved and I am unable to schedule the packages.
February 2, 2007 at 1:02 am
Try to open the package with SSIS and generate a new GUID.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply