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@.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...
>
|||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...
>
|||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...[vbcol=seagreen]
> 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...
not.[vbcol=seagreen]
and[vbcol=seagreen]
these
>
|||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...
> not.
> and
> these
>
>
|||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...
>
>
Showing posts with label wrong. Show all posts
Showing posts with label wrong. Show all posts
Friday, March 9, 2012
Help! Are my DTS Packages gone for good?
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...
>|||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...
>|||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...
not.[vbcol=seagreen]
and[vbcol=seagreen]
these[vbcol=seagreen]
>|||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...
> not.
> and
> these
>
>|||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 uninstall
ed
> 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...
>
>
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...
>|||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...
>|||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...
not.[vbcol=seagreen]
and[vbcol=seagreen]
these[vbcol=seagreen]
>|||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...
> not.
> and
> these
>
>|||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 uninstall
ed
> 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...
>
>
Help! Are my DTS Packages gone for good?
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
> >
> >
>
>
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
> >
> >
>
>
Wednesday, March 7, 2012
help!
sql2k sp3
I accidentally started restoreing the wrong db. I
cancelled it and now its in a load state. Can I just put
it back!!!
Your only recourse to restore from your latest database backup.
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@.phx.gbl...
> sql2k sp3
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!
I accidentally started restoreing the wrong db. I
cancelled it and now its in a load state. Can I just put
it back!!!
Your only recourse to restore from your latest database backup.
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@.phx.gbl...
> sql2k sp3
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!
Monday, February 27, 2012
help!
sql2k sp3
I accidentally started restoreing the wrong db. I
cancelled it and now its in a load state. Can I just put
it back!!!Your only recourse to restore from your latest database backup.
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@.phx.gbl...
> sql2k sp3
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!
I accidentally started restoreing the wrong db. I
cancelled it and now its in a load state. Can I just put
it back!!!Your only recourse to restore from your latest database backup.
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@.phx.gbl...
> sql2k sp3
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!
help!
sql2k sp3
I accidentally started restoreing the wrong db. I
cancelled it and now its in a load state. Can I just put
it back!!!>--Original Message--
>sql2k sp3
>I accidentally started restoreing the wrong db. I
>cancelled it and now its in a load state. Can I just put
>it back!!!
>.
>|||Your only recourse to restore from your latest database backup.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@.phx.gbl...
> sql2k sp3
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!
I accidentally started restoreing the wrong db. I
cancelled it and now its in a load state. Can I just put
it back!!!>--Original Message--
>sql2k sp3
>I accidentally started restoreing the wrong db. I
>cancelled it and now its in a load state. Can I just put
>it back!!!
>.
>|||Your only recourse to restore from your latest database backup.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:43fa01c47ff4$26cc0870$a301280a@.phx.gbl...
> sql2k sp3
> I accidentally started restoreing the wrong db. I
> cancelled it and now its in a load state. Can I just put
> it back!!!
Help!
Can anyone explain me what i am doing wrong:
I have a script that creates a linked server to them exec
a cmd through it.. when i do this through a cursor i get
this error:
MSDTC on server XPTO is unavailable (whcih is not true)
The operation could not be performed because the OLE DB
provider was unable to begin a ditributed transaction.
However if i do it seperatley.. without cursor.. it works..
Can anyone help me?
P.S
I posted a previous question asking about how to insert
sp_space used in a table.. however either way suggest
doesnt work.. any other suggestions?First of all choose an appropriate subject for your
posting. We all need help here but obviously some are
expert in one domain and others in a different domain.
Your subject does not help your cause.
Second what verison of Sql are you using? Can you post the
actual error message and text. There are a few bugs with
Linked servers and i suspect you are encoutering one.
>--Original Message--
>Can anyone explain me what i am doing wrong:
>I have a script that creates a linked server to them exec
>a cmd through it.. when i do this through a cursor i get
>this error:
>MSDTC on server XPTO is unavailable (whcih is not true)
>The operation could not be performed because the OLE DB
>provider was unable to begin a ditributed transaction.
>However if i do it seperatley.. without cursor.. it
works..
>Can anyone help me?
>P.S
>I posted a previous question asking about how to insert
>sp_space used in a table.. however either way suggest
>doesnt work.. any other suggestions?
>.
>
I have a script that creates a linked server to them exec
a cmd through it.. when i do this through a cursor i get
this error:
MSDTC on server XPTO is unavailable (whcih is not true)
The operation could not be performed because the OLE DB
provider was unable to begin a ditributed transaction.
However if i do it seperatley.. without cursor.. it works..
Can anyone help me?
P.S
I posted a previous question asking about how to insert
sp_space used in a table.. however either way suggest
doesnt work.. any other suggestions?First of all choose an appropriate subject for your
posting. We all need help here but obviously some are
expert in one domain and others in a different domain.
Your subject does not help your cause.
Second what verison of Sql are you using? Can you post the
actual error message and text. There are a few bugs with
Linked servers and i suspect you are encoutering one.
>--Original Message--
>Can anyone explain me what i am doing wrong:
>I have a script that creates a linked server to them exec
>a cmd through it.. when i do this through a cursor i get
>this error:
>MSDTC on server XPTO is unavailable (whcih is not true)
>The operation could not be performed because the OLE DB
>provider was unable to begin a ditributed transaction.
>However if i do it seperatley.. without cursor.. it
works..
>Can anyone help me?
>P.S
>I posted a previous question asking about how to insert
>sp_space used in a table.. however either way suggest
>doesnt work.. any other suggestions?
>.
>
Subscribe to:
Posts (Atom)