watuni2000@yahoo.co.nz (Tyler Smith Watu) wrote in message news:<2f3438a4.0410140800.709e5d6e@posting.google.com>...
> There is a truncate,backup and move job.
> Seperately everything works fine but together
> the job fails consistently
> The intention here is to let the jobs precede each other.
> Is failure when grouped a normal behaviour in sql server or am I missing
> something??
>
> TIA
>

"Tyler Smith Watu" <watuni2000@yahoo.co.nz> wrote in message
news:2f3438a4.0410140800.709e5d6e@posting.google.com...
> There is a truncate,backup and move job.
> Seperately everything works fine but together
> the job fails consistently
> The intention here is to let the jobs precede each other.
> Is failure when grouped a normal behaviour in sql server or am I missing
> something??
>
> TIA
>
> TY

"Tyler Smith Watu" <watuni2000@yahoo.co.nz> wrote in message
news:2f3438a4.0410150443.6c165c74@posting.google.com...
> watuni2000@yahoo.co.nz (Tyler Smith Watu) wrote in message
> news:<2f3438a4.0410140800.709e5d6e@posting.google.com>...
>> There is a truncate,backup and move job.
>> Seperately everything works fine but together
>> the job fails consistently
>> The intention here is to let the jobs precede each other.
>> Is failure when grouped a normal behaviour in sql server or am I missing
>> something??
>>
>> TIA
>>
>
>
> The job finally finished and the error was "cannot perform backup or
> restore
> operation within a transaction"
>
> --This is what I will like to do in order
>
> Everthing works seperately but since the order matters
> I will ideally like to
> 1) truncate the transanction log
> 2)backup the database
> 3) copy the database to another server.
> I like to schedule this so that one precedes the other
> Individaully everything works perfect but since the
> log needs to be truncated ,before a backup and the
> backup needs to finish before a copy
> I will appreciate help on how to do
>
> Tried to put all this in order as a single job and it failed
>
>
> Any help will be greatly appreciated
>
> TY