Hi there...

Quick question - how do I backup the packages I've created?

--
I doubt, therefore I might be.

If you are saving your packages to SQL Server, they are
stored in the msdb database. Backing up this database
effectively backs up your DTS packages.

-Sue

On Mon, 5 Apr 2004 16:37:52 +0200, "Kim Noer" <kn (AT) nospam (DOT) dk>
wrote:

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote

Thanks a bunch, then I already got it covered . So what do you do in a
restore situation? Then I have two msdb databases, do I just detach the
'standard' one, and then attach the backup?

--
I doubt, therefore I might be.

If you restore msdb, how would you have two msdb databases?
The existing database would be overwritten which is
generally what you want in a restore situation. You can find
information on restoring system databases in books online.
You can also find information in the following article:
http://support.microsoft.com/?id=304692
If you are only wanting to revert to previous versions of
DTS packages, right click on the package and select
versions. You can open up old versions of the package from
here. You can also save packages out to files. You can find
more information and a utility for this at:
http://www.sqldts.com/default.aspx?202

-Sue

On Mon, 5 Apr 2004 16:58:49 +0200, "Kim Noer" <kn (AT) nospam (DOT) dk>
wrote:

Kim Versioning can also be controlled by saving the packages off as Structured Storage Files and Adding them to a VSS project folder.

Sue Hoegemeier wrote:
I forgot to thank you for your answer - so well thank you .

--
Speaker : "And here we are at the start of the second semifinale of the
100 yards for people without any sense of direction."

So .well...your welcome
Seriously though...thanks for posting back.

-Sue

On Sat, 10 Apr 2004 17:55:01 +0200, "Kim Noer"
<kn (AT) nospam (DOT) dk> wrote: