Post reply

lost dts package

  • April 27, 2004 at 6:54 am

    #59661

    hi,

     i have created a DTS package and it was running fine. i had a some problem with my sql installation so i rebuild the DB using rebuildm command line utility.

    sql installation is fine now.

    i noticed that eventhough user created db was removed from enterprise manager i was able to attach it back using the attach wizard because the databases are still in the installation directory

    my problem is that i have forgotten to save my DTS package. Is it saved anywer in my hard disk or is there any way for me to retrieve it back????

     

    Plz help.....

  • April 27, 2004 at 7:05 am

    #504323

    You have no backup of the MSDB database?


    Shamless self promotion - read my blog http://sirsql.net

  • April 27, 2004 at 6:36 pm

    #504406

    nop

  • April 28, 2004 at 5:00 am

    #504463

    Unfortunately the package is lost...


    Shamless self promotion - read my blog http://sirsql.net

  • July 22, 2004 at 4:42 am

    #515631

    I have a similiar problem, but i have the original msdb database file saved. Would it be possible for me to just copy it over the old one ?? ( A fresh installation msdb. )

  • July 28, 2004 at 3:21 pm

    #516667

    Yes, You should be able to restore MSDB over the current database. Make sure SQL agent is turned off and all the connection to MSDB are closed.

    You will learn your lesson to always keep backup of system databases. I learned that hard way.

  • July 28, 2004 at 5:33 pm

    #516672

    Its also a good idea to Save your DTS Packages as Structured Storage Files and Store in a Code Vault such as Visual SourceSafe or StarTeam.

Viewing 7 posts - 1 through 6 (of 6 total)

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