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)
 How to do Backup for Packages in SQL SERVER

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-14 : 06:59:50
Mohammed writes "Dear Sir/Madam :

I am new user in the SQL Server and use the SQL Server by creating some packages .These packages are to execute Report from Oracle DB.

I want to do a backup for these Packages where I have about 60 package ."

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-14 : 12:56:55
here is a good article the outlines the ways to move (or backup) dts packages http://www.sqldts.com/default.aspx?204

you can also use their DTS backup 2000 app http://www.sqldts.com/default.aspx?272



-ec
Go to Top of Page

homebrew
Posting Yak Master

114 Posts

Posted - 2005-07-21 : 15:55:01
If you just want a backup for disaster recovery purposes, then back up your MSDB database, because that's where your DTS packages reside. If you're backing up your databases regularly already (I hope so) then you've already got backups of your DTS packages.
Go to Top of Page
   

- Advertisement -