Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2004-06-14 : 02:30:41
|
| Hi there,Windows 2000 and SQL 7.0 sp4I recently had a server crash and had to rebuild. One DTS package wasnt backed up and needs to be recreated. Is it possible to get the package back from one of the backed up system databases?thanks - matt |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-14 : 05:10:07
|
| Look at the MSDB database.-------Moo. :) |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-06-14 : 05:11:30
|
| They live in sysdtspackages in the MSDB database.It is possible, I had to do it recently. I had the mdf and ldf from the old database server, I attached the files under a different name on the new box and inserted the rows from the old database to the new one.Damian |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-14 : 07:50:03
|
| If he has a backup, he just needs to restore the msdb database on the new server. That will restore both his jobs and DTS packages.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
DTS packages - which system database has them?