Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Backup/Restore DTS

Author  Topic 

sardinka
Posting Yak Master

142 Posts

Posted - 2006-09-21 : 11:07:13
Does some one know how to back up a dts and then restore from a backup?

Rishi Maini SQL2K5 Admin
Yak Posting Veteran

80 Posts

Posted - 2006-09-21 : 11:43:14
DTS Packages are stored under the MSDB Databases, so backing up the MSDB Database will backup DTS also.

Thanks
Rishi Maini
Go to Top of Page

sardinka
Posting Yak Master

142 Posts

Posted - 2006-09-21 : 13:27:40
can you tell me how to restore DTS from msdb?
Go to Top of Page
   

- Advertisement -