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
 SQL Server Administration (2000)
 Backup DTS

Author  Topic 

mcordewener
Starting Member

19 Posts

Posted - 2006-01-12 : 03:30:32
Hi there,

does anybody know how we can backup a dts without using the option save as. We would like to schedule this backup to backup all the dts'en on the server.

Greetz,

Marcel

Westley
Posting Yak Master

229 Posts

Posted - 2006-01-12 : 04:08:57
Hi,
All DTS definition are stored in msdb, so you can backup your msdb which will backup all your DTS stored on the server.
Go to Top of Page

mcordewener
Starting Member

19 Posts

Posted - 2006-01-12 : 04:38:07
Thnx
Go to Top of Page
   

- Advertisement -