Hello All,
I need to migrate our databases from one server to another. Now since these
databases have DTS packages/scheduled jobs associated with them, should i
just restore the MSDB database on the target server to recover all settings?
Or is there any alternate way that will be best for my scenario?
Thanks
Manny
Tibor Karaszi - 17 Mar 2008 15:19 GMT
I would script the job (right-click in EM). And Save DTS packages as files and from those files open
and save them in the new instance.

Signature
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
> Hello All,
>
[quoted text clipped - 7 lines]
>
> Manny