|
Home > Archive > MS SQL Server > May 2005 > Backing up DTS and SQL jobs....
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Backing up DTS and SQL jobs....
|
|
| Jessy Martin 2005-05-31, 1:23 pm |
| I know If I store the DTS packages in SQL Server it will be stored in the
msdb database.
Also all the job scheduling information is stored in the msdb database.
Even though I am taking backup of system databases, I would like to know if
is there any way I can export all the DTS packages and jobs in any different
way. This is only an additional extra precaution incase If I am not able to
restore the system database in the event of disaster.
I am able to open the DTS packages individually and store as .dts file. It
is a time consuming process.
I am using SQL 2K.
Thanks,
J Smith
| |
| pdwight 2005-05-31, 8:23 pm |
| For DTS backup, I use a neat little program called, "DTS Backup 2000." It's
freeware.
"Jessy Martin" < Jessy_Smith79@hotmai
l.com> wrote in message
news:uMDTg4gZFHA.3048@TK2MSFTNGP14.phx.gbl...
>I know If I store the DTS packages in SQL Server it will be stored in the
> msdb database.
>
> Also all the job scheduling information is stored in the msdb database.
>
> Even though I am taking backup of system databases, I would like to know
> if
> is there any way I can export all the DTS packages and jobs in any
> different
> way. This is only an additional extra precaution incase If I am not able
> to
> restore the system database in the event of disaster.
>
> I am able to open the DTS packages individually and store as .dts file. It
> is a time consuming process.
>
> I am using SQL 2K.
>
> Thanks,
>
> J Smith
>
>
| |
| Wayne Snyder 2005-05-31, 8:23 pm |
| Free Backup Software from Darren Green is available at www.sqldts.com
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jessy Martin" < Jessy_Smith79@hotmai
l.com> wrote in message
news:uMDTg4gZFHA.3048@TK2MSFTNGP14.phx.gbl...
>I know If I store the DTS packages in SQL Server it will be stored in the
> msdb database.
>
> Also all the job scheduling information is stored in the msdb database.
>
> Even though I am taking backup of system databases, I would like to know
> if
> is there any way I can export all the DTS packages and jobs in any
> different
> way. This is only an additional extra precaution incase If I am not able
> to
> restore the system database in the event of disaster.
>
> I am able to open the DTS packages individually and store as .dts file. It
> is a time consuming process.
>
> I am using SQL 2K.
>
> Thanks,
>
> J Smith
>
>
|
|
|
|
|