dbTalk Databases Forums  

Restore DTS packages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Restore DTS packages in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Eduardo Greco
 
Posts: n/a

Default Restore DTS packages - 08-26-2004 , 09:57 AM






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



Reply With Quote
  #2  
Old   
Jacco Schalkwijk
 
Posts: n/a

Default Re: Restore DTS packages - 08-26-2004 , 11:54 AM






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





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.