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 |
|
frodriguez
Starting Member
1 Post |
 Posted - 2005-12-29 : 09:44:20
|
| Hi, paws. My server crashed recently, I didn't give to much importance because I knew that having access to the partitions I could recover my DB files and attach my database to my new server, and everything was fine until ... I found that my DTS Packages and Jobs where not in my Attached DB.Now, where can I find these ?Can you help a tormented man ?Thanks in advance.Francisco J |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-29 : 14:20:52
|
Hi frodriguez, Welcome to SQL Team!Not something I know very well, but to keep you busy until someone who really knows comes along  you could look in the MSDB databaseKristen |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-12-29 : 15:25:41
|
| Just restore the MSDB database from the last backup you have from the crashed server. MSDB contains the DTS packages.Note that you will lose any jobs and packages setup in your current MSDB, so you need to save copies of those before you restore the old MSDB backup.CODO ERGO SUM |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-30 : 14:08:35
|
| You could restore the MSDB from the old machine to a "temporary database" with a different name, but I don't know whether its possible to then Export / Import from there into the new MSDB - only a problem if you have some stuff on the new machine that you need to preserve, as MVJ points out.Just thinking out loud ... Kristen |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-01-25 : 16:18:18
|
| Hithe DTS packages are the part of the server and when you restored the DB you will not get these packages.if you have the MSDB backup try restoring it.i always keep a backup of mY DTS by copying it to another serverNitin |
|
|
|
|
|
|
SQL Server crashed, DB files attached but ..