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 package recovery

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-28 : 07:42:11
Suneil writes "Hi,

I was working on DTS packages on SQL2000 on machine1. We had to install SQL 7.0 on the same machine. We had taken a database backup before uninstalling SQL2000. We restored the back-up of the database on SQL2000 on machine2.In the meantime we installed SQL7.0 on Machine1. Now we have lost the DTS packages in both machine1 and machine2. Is there anyway in which we can recover the DTS local packages that were created. Since we are working against strict deadlines, a speedy response will be really appreciated.

thanks and regards,
suneil"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-02-28 : 07:59:21
Restore from the backup of the MSDB database from machine1.

Jay White
{0}
Go to Top of Page
   

- Advertisement -