December 7, 2004 at 8:53 am
We have a Server, due to Hardware failure, that is going to be rebuilt.
I am looking for the best way to save DTS packages and then restore them after the Server is rebuilt.
Thanks for the help!
December 7, 2004 at 9:08 am
Use "DTSbackup 2000" to save your DTS to another server or save them as DTS backup files on your workstation.
December 7, 2004 at 9:08 am
I can think of three methods.
1. Since DTS packages are stored in the MSDB database, back up the database then restore it after the rebuild.
2. Open each package in DTS Designer and save as a structured storage file. This is okay for a few packages, but I wouldn't want to do it for a hundred of them.
3. DTSBackup 2000 from sqldts.com. I haven't tried it, but others have recommended it in these forums. http://www.sqldts.com/default.aspx?242
Greg
Greg
December 7, 2004 at 9:55 am
Greg has the three ways to do this. #1 is the quickest way in a disaster, but #3 makes more sense since packages become corrupt and you wouldn't want to restore MSDB if one package got lost.
December 8, 2004 at 3:05 am
If it's just DTS packages you are interested in, you only need the content of the table msdb.dbo.sysdtspackages
Jeet
Thanks Jeet
December 8, 2004 at 5:45 am
Maybe this will help... I have written a .Net app that will allow a sysadmin the ability to compare DTS Packages between servers and copy a newer version or overwrite all versions with the newest version from source to destination server.
I use this utility to sync development, test and production environments. I have also used this utility to grab latest versions from our development environment to my laptop then deliver the packages to a client server.
Used SQLDMO to build a server list, allows for both windows SSPI logon or SQL user/pass logon on both source and destination servers individually.
I'd be happy to send you a current copy to try out. I still have a few features to add to it, such as compare all source and destination packages with a single click, and the ability to backup all packages to a storage file archive and allow restore from there. But as is, it provides a simple and fast way of comparing and moving packages between servers.
If interested, I'd be happy to send you a copy to tryout. Email me at: mgercevich_nospam@gmail.com (remove '_nospam') and I'll send you out a copy.
-Mike
December 8, 2004 at 7:56 am
DTSBackup 2000 is the way to go. http://www.sqldts.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply