April 17, 2002 at 10:41 am
All of my packages that were in the Repository have come up missing! I have weekly backups of the master and other databases.... where can I find these and how can I restore them? Thank you in advance!
Shawn
April 17, 2002 at 11:13 am
msdb Database is where they are restored. I would restore either to another database or another test server and push them into the proper table (see other threads not on hand right now). If you choose to restore over the current msdb you will need to stop Agent and you will loose anything else that was changed after that backup was done as well.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 18, 2002 at 2:33 pm
We have encountered the same problem. Hit F5 a couple of times. The packages are still there, it's just the display that doesn't show it. Sometimes they come up with half the name missing. Just keep hitting F5.
If you don't need to store metadata about the packages dont keep them in the repository as the packages can corrupt more easily there.
You could consider backing up your DTS packages to the file system as COM packages.
We do this and then backup the drive to tape every night.
Right click in the designer and select Save AS.
There is a tool to automate this here, although I have not tried it out yet myself:
http://www.sqldts.com/linkredir.asp?linkid=242&url=http://www.sqldts.com/download/DTSBackup2000.msi
Hope this helps
April 18, 2002 at 4:56 pm
Yeah, I discovered this yesterday. I was running around frantically and my network admins were trying to find good copies in the nightly backups and suddenly! bam! there they were. I will be saving these to files this very day.
I'm running sql 7 - does this happen in other versions as well?
April 19, 2002 at 4:06 pm
We upgraded to 2000 about 6 months ago and still get the same problem. Not refreshing the GUI seems to be a general failing of SQL Server to date, hopefully someone at Microsoft is reading this and working on a patch right now:)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply