Post reply

Urgent: save dts

  • November 10, 2008 at 5:42 am

    #132068

    Please, I have an urgent question: tomorrow an old sql server will be reset, I think it could be useful to save some datafiles and dts. The structure of dts are stored in msdb, so if I keep a backup of it (and of all system databases) I am sure I could recreate the dts?

    Or is there a way to export its strucure?

    The databases on this server are no longer in use, because they have been migrated to a new version, but on that machine there is the history of transforming data for the new structures.

    Many thanks in advance!

    sb

  • November 10, 2008 at 5:59 am

    #896236

    http://www.sqldts.com, DTS backup 2000

    Wilfred
    The best things in life are the simple things

  • November 10, 2008 at 6:04 am

    #896239

    many, many thanks!

    sb

  • November 10, 2008 at 10:18 am

    #896412

    If there aren't too many, you could save them to the new server.

    Open the package, "Save As", Maybe prefix the name like "OldServer_DTS_Name", then save it to the new server. But not a good idea if you don't want to clutter up the new server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply