MS SQL Server DTS - Recover DTS

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Recover DTS

Shima

2005-07-27, 8:24 pm

How can I recover a DTS without recover a old msdb database over current msdb ?

Allan Mitchell

2005-07-27, 8:24 pm

Restore the MSDB to Another database name
Now export sysdtspackages from the newly recovered db to your real msdb.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

"Shima" <Shima@discussions.microsoft.com> wrote in message
news:5B5F13A0-8E53-4B2A-A838- 0C44F28A74D6@microso
ft.com...
> How can I recover a DTS without recover a old msdb database over current
> msdb ?
>

Sponsored Links