Something was wrong with my local SQL Server environment. I was unable to
connect to my own SQL Server running on my own workstation. So I uninstalled
and reinstalled. I knew my database files would be safe and sure enough, I
just reattached them after reinstalling.

But where are my DTS Packages???? Are these gone for good, or are these
still in some location from which they can be recovered?

Thanks for your advice,

Joe Geretz

depends. If you save the DTS packages as VB files, you still have a change
to find them in OS directory. Otherwise, they are gone after msdb is
uninstalled.

Don't you have a msdb backup?

"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

do you have msdb backup? any DTS backup?


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

Point well taken. All source is saved to Visual Source Safe but database
procs and utilities - weak link! I guess I'd always assumed these to be
resident in one particular database or another, but obviously they're not.

How do you do a DTS Backup? We use DTS to backup our databases from one
server to another, but backing up the DTS packages themselves? I didn't know
you could do that.

Thanks,

- Joe Geretz -

"Patrick" <patriarck (AT) gmail (DOT) com> wrote

You can save as VBscript or just save as .dts file


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

Patrick,

DTS saved as VB cannot be saved back to a server. Not as easy. You would
have to include it into a VB snippet and save it from VB. That would loose
you graphical layout and comments. Regular way would be backing up msdb or
saving DTS as structured files.

Ilya
"Patrick" <patriarck (AT) gmail (DOT) com> wrote

Yes, very important, depending to whom you speak.... BACK UP YOUR SYSTEM
DATABASES...ALWAYS!

Sincerely,


Anthony Thomas


"Ilya Margolin" wrote:

If you didn't save them as files, just restore your backup of msdb.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

Guys you can get a realy good tool called DTSBackup from SQLDTS.com.

We back up 3000 scripts weekly. Just for peace of mind.



"Tibor Karaszi" wrote: