May 13, 2004 at 12:40 pm
A developed accidentally deleted a DTS package.
1. Can I retrieve the deleted package from a prior backup of MSDB when I restore the MSDB database?
2. Once MSDB is restored, save the DTS package as a VB .bas file.
3. Restore the MSDB again from the most recent backup.
4. Can the VB .bas file be "imported" into the MSDB database ( #3 ) ?
May 13, 2004 at 2:37 pm
Restore the database in which the dts package resides, but restore it to a NEW database using RESTORE ... WITH MOVE. Don't overwrite your database or the database files!
RESTORE DATABASE mydb_temp
FROM DISK = 'x:\SQL_Backups\mydb_backup.bkp'
WITH RECOVERY,
MOVE 'msdbdata' TO 'f:\SQL_Data\mydb_temp_Data.mdf',
MOVE 'msdblog' TO 'd:\SQL_Logs\mydb_temp_Log.ldf'
Then just edit the dts package and save it back to the original database, and you can delete the temp database.
Steve
May 14, 2004 at 8:03 am
It will also depend, where you save your DTS Package
May 14, 2004 at 8:03 am
It will also depend, where you save your DTS Package
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply