is there a procedure for recovery of dts packages of a crashed server?
I have a colleague who was developping a dts package on a test server
off course, the inevitable happened without a backup at hand

where can I find the DTS packages and how can I get them back

PS: it was a diskcrash with a corrupt MFT and some bad blocks
file recovery from the disk is still possible for the moment

thnx

Was your colleague saving the dts package to SQL Server? If so, the package
data can be found in the sysdtspackages table of msdb database. Do you have
a recent msdb backup or msdb data and log files available?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"chriske911" <chriske911nospam (AT) yahoo (DOT) com> wrote

is there a procedure for recovery of dts packages of a crashed server?
I have a colleague who was developping a dts package on a test server
off course, the inevitable happened without a backup at hand

where can I find the DTS packages and how can I get them back

PS: it was a diskcrash with a corrupt MFT and some bad blocks
file recovery from the disk is still possible for the moment

thnx

thnx, found it eventually on this site:
<http://www.sqldts.com/default.aspx?204>

and completed the restore succesfully

next question maybe is how to perform an automated backup for DTS
packages only
so not the complete msdb data file

grtz

You could do this a number of ways but one of them might be to export
sysdtspackages to a text file every night and save that off somewhere.




"chriske911" <chriske911nospam (AT) yahoo (DOT) com> wrote

can I use this backup txt files to import it into another server?
as far as I can see the records in the sysdtspackages table are binary
how can I make a file out of these records?

thnx

Have a look here

Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)


"chriske911" <chriske911nospam (AT) yahoo (DOT) com> wrote