Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup and Restore 1

Status
Not open for further replies.

GJParker

Programmer
Jul 4, 2002
1,614
GB
I have accidently deleted a DTS Local Package. for Future reference is it possible to backup and restore these items ?

Gary Parker
MIS Data Analyst
Manchester, England
 
If you are holding them on the server they are held in msdb..sysdtspackages.
A restore of msdb will get it back but probablt better to restore it to another server and copy the package or the row from the table.

Also consider loading packages from fikles and keeping them in sourcesafe then you won't have this problem.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Thanks for that Nigel.



Gary Parker
MIS Data Analyst
Manchester, England
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top