DTS Packages are stored in the MSDB database, so if you have a backup of
this database you can restore that. If you only have the file, I would
create a new MSDE instance, shut it down, and copy the data file and the log
file over the existing .mdf file and .ldf files. I think that will work but
not 100% sure. What you can also try is follow the steps outlined in
http://support.microsoft.com/default...;en-us;Q224071
but instead of copying the msdb to a new location, just attach the msdb
database you want to recover.
--
Jacco Schalkwijk
SQL Server MVP
"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote
Quote:
Hi there...
I have uninstalled a MSDE version but there were some DTS packages on it.
Anyway, the Data folder remains in my computer.
Is there anyway to restore these packages in a another server/instance?
Which databases are needed to recover them?
Thank you very much...
Eduardo |