March 30, 2004 at 8:46 am
I have backing up all of my Databases and unfortunately my server crashed. I have restored all of the DB's including MSDB which from my understanding is where all my DTS packages live. The problem is I do not see my DTS packages there. Where are they and how can I restore them?
March 30, 2004 at 10:50 pm
Hi, If you hav backed up MSDB prior then all DTS packages will exist after restore as this is where they are normally stored. A possibility is that you have not been storing the DTS packages in SQL Server (hence the MSDB database) check that you have not been saving the DTS packages externally to SQL Server, if you have then they should be where you have saved them. Also after restore of msdb make sure you have 'refreshed' the various objects in EM as often the data you see in EM is not current and reflects what was there prior to changes such as restoring db's. i.e refresh the data transformations services and its sub item local packages then see if they appear.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply