April 27, 2004 at 6:54 am
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
You have no backup of the MSDB database?
April 27, 2004 at 6:36 pm
nop
April 28, 2004 at 5:00 am
Unfortunately the package is lost...
July 22, 2004 at 4:42 am
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
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
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