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 Geretzdepends. 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@.nospam.com> wrote in message
news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> 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
>|||do you have msdb backup? any DTS backup?
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> 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
>|||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@.gmail.com> wrote in message
news:uEWLQtpwEHA.1452@.TK2MSFTNGP11.phx.gbl...
> do you have msdb backup? any DTS backup?
>
> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
>> 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
>>
>|||You can save as VBscript or just save as .dts file
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:OcFw21pwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> 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@.gmail.com> wrote in message
> news:uEWLQtpwEHA.1452@.TK2MSFTNGP11.phx.gbl...
>> do you have msdb backup? any DTS backup?
>>
>> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
>> news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
>> 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
>>
>>
>|||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@.gmail.com> wrote in message
news:%23xEVEIrwEHA.1392@.tk2msftngp13.phx.gbl...
> You can save as VBscript or just save as .dts file
>
> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> news:OcFw21pwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> > 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@.gmail.com> wrote in message
> > news:uEWLQtpwEHA.1452@.TK2MSFTNGP11.phx.gbl...
> >> do you have msdb backup? any DTS backup?
> >>
> >>
> >> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> >> news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> >> 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
> >>
> >>
> >>
> >>
> >
> >
>|||Yes, very important, depending to whom you speak... BACK UP YOUR SYSTEM
DATABASES...ALWAYS!
Sincerely,
Anthony Thomas
"Ilya Margolin" 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@.gmail.com> wrote in message
> news:%23xEVEIrwEHA.1392@.tk2msftngp13.phx.gbl...
> > You can save as VBscript or just save as .dts file
> >
> >
> > "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> > news:OcFw21pwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> > > 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@.gmail.com> wrote in message
> > > news:uEWLQtpwEHA.1452@.TK2MSFTNGP11.phx.gbl...
> > >> do you have msdb backup? any DTS backup?
> > >>
> > >>
> > >> "Joseph Geretz" <jgeretz@.nospam.com> wrote in message
> > >> news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> > >> 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
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
>
>|||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@.nospam.com> wrote in message
news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> 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
>|||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:
> 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@.nospam.com> wrote in message
> news:%23nGKAopwEHA.2172@.TK2MSFTNGP14.phx.gbl...
> > 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
> >
> >
>
>
