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)
 DTS Backup and Restore

Author  Topic 

cloudie
Starting Member

1 Post

Posted - 2005-01-31 : 23:34:46
Do anyone know about this? Im using SQL 2000 Server.Thanks in advance.

rishimainidba
Starting Member

30 Posts

Posted - 2005-01-31 : 23:59:43
Whenever you save your DTS Packages in SQL Server they are stored under "msdb" database in "sysdtspackages" table.
So its all about backing up and restoring your "msdb" Database of SQL Server.

Other Means of Saving DTS packages is to store them in form of VB files and Meta Data Services. So u can manually Backup and restore these files on OS Level

Regards
Rishi
Go to Top of Page
   

- Advertisement -