Red Gate forums :: View topic - Lost DTS packages - can I use MSDB backup in the compare
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
DTS Package Compare 2
DTS Package Compare 2 forum

Lost DTS packages - can I use MSDB backup in the compare

Search in DTS Package Compare 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
Steve C



Joined: 02 Mar 2006
Posts: 5

PostPosted: Thu Jun 01, 2006 9:47 pm    Post subject: Lost DTS packages - can I use MSDB backup in the compare Reply with quote

We lost the DTS packages (unknown) - I'd like to know if you can use input from a backup file of the MSDB and sync to a server instance?

Next would be sync the server from the backup?

Is there another way to restore DTS -- These were not assigned to a DB - we tried restore of the database but the DTS packages were not with it.
Steve
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6588

PostPosted: Thu Jun 08, 2006 6:33 pm    Post subject: Reply with quote

Hello Steve,

I think it depends... I have done this before. A user had sent me a backup of his MSDB and I had restored it to a crash server and was able to analyze all of the DTS packages from the crash server, then use Enterprise Manager to save them as structured storage and import them into other servers.

You could have problems, though, if you use custom tasks which are COM objects that exist as files and are registered on the server. You'd need to locate all of those files and copy them to the new server and register them with regsvr32.exe.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group