shakti,

SQL Server do not provide any tool or utility to recover data updated or deleted accidently. for this reason companies hire DBA to take bakups so that in case of...

execute this query.

INSERT INTO NEWSERVER.MSDB.DBO.SYSDTSPACKAGES

SELECT * FROM OLDSERVER.MSDB.DBO.SYSDTSPACKAGES

or export all records from msdb.dbo.sysdtspackages to new server.

I am sure it will help.

I faced the same problem 2 months ago, when i moved 287 GB of database to our new production server.

Here are the steps you can follow.

1. Truncate LOG files of...