dbTalk Databases Forums  

DTS Recovery

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


Discuss DTS Recovery in the microsoft.public.sqlserver.dts forum.



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

Default DTS Recovery - 11-04-2003 , 01:49 PM






We lost our SQL 2000 Server to a disk error. We had a few
DTS packages but they are gone after reinstall. Some of
the old SQL directories are still accessable but I can't
find the DTS definitions to restore. Does anybody know
where they are stored and how I can get the back without
recreating them from memory?
Thanks.

Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: DTS Recovery - 11-04-2003 , 02:09 PM






If you were saving your packages to SQL Server, they are
stored in msdb....so a restore of msdb database will bring
the packages back.

-Sue

On Tue, 4 Nov 2003 11:49:55 -0800, "Bri"
<beshleman (AT) aains (DOT) com> wrote:

Quote:
We lost our SQL 2000 Server to a disk error. We had a few
DTS packages but they are gone after reinstall. Some of
the old SQL directories are still accessable but I can't
find the DTS definitions to restore. Does anybody know
where they are stored and how I can get the back without
recreating them from memory?
Thanks.


Reply With Quote
  #3  
Old   
Bri
 
Posts: n/a

Default Re: DTS Recovery - 11-04-2003 , 02:29 PM



Thanks you, Thanks you, Thank you.

Quote:
-----Original Message-----
If you were saving your packages to SQL Server, they are
stored in msdb....so a restore of msdb database will bring
the packages back.

-Sue

On Tue, 4 Nov 2003 11:49:55 -0800, "Bri"
beshleman (AT) aains (DOT) com> wrote:

We lost our SQL 2000 Server to a disk error. We had a
few
DTS packages but they are gone after reinstall. Some of
the old SQL directories are still accessable but I can't
find the DTS definitions to restore. Does anybody know
where they are stored and how I can get the back without
recreating them from memory?
Thanks.

.


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.