Wednesday, March 28, 2012

Scheduling DtsBackup2000?

Dear folks,
Is it possible? Show us a instatiable model such application? I would like
to develop any which might be able to start and do the wly transferences
to disk (.dts,.dtb).
Thanks for any comment or idea,Hi Enric,
What i do is make a .cmd file that contains all the DTSBackup2000cmd.exe
command lines
I then use SQL Server Agent and scheduled a CmdExec job that executes the
.cmd file nightly
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:D86F5040-3C86-44D9-AB08-1A2370A390F0@.microsoft.com...
> Dear folks,
> Is it possible? Show us a instatiable model such application? I would like
> to develop any which might be able to start and do the wly
> transferences
> to disk (.dts,.dtb).
> Thanks for any comment or idea,
>|||Right. Do you mind show me a few ones?
thanks
"Ryan" wrote:

> Hi Enric,
> What i do is make a .cmd file that contains all the DTSBackup2000cmd.exe
> command lines
> I then use SQL Server Agent and scheduled a CmdExec job that executes the
> ..cmd file nightly
> --
> HTH. Ryan
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:D86F5040-3C86-44D9-AB08-1A2370A390F0@.microsoft.com...
>
>|||Here's how...
Open Notepad paste the following in
DTSBackup2000Cmd.exe /SS (local) /SE /T /DS OffSite /DU sa /DP password
Save AS - DTSBackup.cmd
Then navigate your way to Jobs in EnterPrise Manager and schedule the
running of DTSBackup.cmd
Management\SQL Server Agent\Jobs
Right Click\New Job\Steps\New\Type\CmdExec
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:4A0F1FA2-FB8E-4BF0-AD1C-6697D8163B24@.microsoft.com...
> Right. Do you mind show me a few ones?
> thanks
> "Ryan" wrote:
>|||Thanks a lot Ryan.
"Ryan" wrote:

> Here's how...
> Open Notepad paste the following in
> DTSBackup2000Cmd.exe /SS (local) /SE /T /DS OffSite /DU sa /DP password
> Save AS - DTSBackup.cmd
> Then navigate your way to Jobs in EnterPrise Manager and schedule the
> running of DTSBackup.cmd
> Management\SQL Server Agent\Jobs
> Right Click\New Job\Steps\New\Type\CmdExec
>
> --
> HTH. Ryan
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:4A0F1FA2-FB8E-4BF0-AD1C-6697D8163B24@.microsoft.com...
>
>

No comments:

Post a Comment