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.
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. |
 |
|
mcordewener
Starting Member
19 Posts |
Posted - 2006-01-12 : 04:38:07
|
Thnx |
 |
|
|
|
|