DTS packages backup ?

Hi,

On our dev machine there are some DTS packages in the DataTransformationServices\LocalPackages. Our dev machine & DB is backed up every day (.bak file and backup of data files)
We had a crash and had to restore the DB's, now all DTS packages are gone !

We're are they saved ? Can I get them back somehow ?DTS packages stored on the server are in msdb.

-PatP|||DTS packages will be saved in MSDB database and if you're not maintained any MSDB backup then assume they are gone.

Its better and advisable to maintain regular backups for system databases too.|||Thanks for the info,
but ofcourse they didn't backup the msdb...|||aha, I found a backup of the data files,
how can I know get it back,
I tried a detach/attach of the msdb db but he refuses to detach it ?|||You probably want to read up on Restoring the model, msdb, and distribution Databases (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp) before you start. There are some gotchas that you need to consider.

You'll need to use SQL Enterprise Mangler, or BACKUP DATABASE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_7cft.asp) to make a backup, then move that to the new box and restore it.

-PatP|||I did that, now I got my jobs back, but no dts packages ?|||Hmmm... Sorry, no clue. It has never failed me.

-PatP|||Then consider there is no chance to retrieve the DTS packages, consider this as a lesson and maintain regular backups for SYSTEM Databases too.

By any chance are the packages saved to a .VBscript files.|||To make a backup of all kinds of DTS packages or to transfer DTS packages between servers, please use the DTS Backup 2000 tool. This a very handy tool and it works very good; I use it myself ;) very often.

To get this tool please visit following URL: http://www.sqldts.com/default.aspx?202

I hope this helps to prevent new problems in the future.

Greetz,
DePrins :)|||Check the contents of sysdtspackages in the newly restored MSDB.|||this is antother reason that i always save these things as com files
you can place them in a centrally stored shared dir and back them up every night.

on a side note
you should create a job that backs up your master model and msdb dbs and schedule it for every night.
it's a whole lot better then running rebuildm.exe|||You can also do this by saving them as structured files. They're a little easier to handle and explain to the non-technical savvy people. :)|||"com file" = "com structured storage file"|||Thought you were referring to the visual basic file option. Oh well, who cares. Big thing is to make sure you save them.