Backing up/recovery of DTS Packages

[StevenK]

We've recently had to re-install our copy of SQL Server 7.0 on one of our machines. Following the uninstall/reinstall the database files ('.mdf' and '.ldf' files) were maintained and we were able to reattach these databases and pick up where we left off with them.
Unfortunately the DTS packages we had recently laboured over appeared to be lost.
Is there any way to retrieve these (following the uninstall/reinstall) or should we have been backing these up on a regular basis - and if this is the case - then what is the best way to do this.
We are now looking at a process of recreating the DTS packages setting up the column breaks for the feeding from text files to import data from.
Any help would be appreciated.
Steve

 

[RickCole]

If you had been saving your DTS packages in the location SQL Server then these will have been held in your msdb database. If you had no backup of this database then you will have lost your packages.

As this database also holds all your scheduled jobs your msdb database should probably as a minimum be backed up on a daily basis.

Rick.