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 |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-10-03 : 11:39:37
|
| What is the best way to backup my DTS. Can this task be scheduled? |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-03 : 12:42:46
|
| If its using SQL Server Storage or Repository (Meta Data Services in 2000) then both of these are in the msdb database, so when you back that database up, you are backing up your DTS packages. You can also save them as files and back up as any other file. Check out[url]http://www.sqldts.com/default.aspx?6,105,202,0,1[/url][url]http://www.sqldts.com/default.aspx?6,105,242,0,0[/url]HTHJasper Smith |
 |
|
|
|
|
|
Backup DTS