Don't update Files rtn, SQL secundary with warnings 208

I have 3 sql Server 2000 with log shipping, but the last files .rtn is
191207, don't update. In SQL Primary don't have events, in SQL Secundary
there are many warnings with the next descripcion:
Source: SQLserveragent, category: Job Engine, Type: Warning, Event ID:208
SQL server Sheduled Job 'Log Shipping Restore for
(local).BPP_logshipping'(0x6DA834715FFBFD4C8DF2F9226CA343F)
Status: Failed - Invoked on 2008-01-21 09:29:00 - Messae: The job failed.
The job was invoked bye schedule (Schedule 1). The lst step to run was step
1 (Log Shipping Restore).
In SQL enterpise, jobs, there is a Log shipping restore for local... in red.
the files rtn in SQL Secundary is the same in SQL Primary.
I don't find solution.Hi
I am not a log shipping expert, but it sounds like the backup may be
corrupt. I would stop the log shipping jobs, take a new backup of the
database and restore it on the secondary server and then restart the log
shipping jobs.
John
"Kerly" wrote:
> I have 3 sql Server 2000 with log shipping, but the last files .rtn is
> 191207, don't update. In SQL Primary don't have events, in SQL Secundary
> there are many warnings with the next descripcion:
> Source: SQLserveragent, category: Job Engine, Type: Warning, Event ID:208
> SQL server Sheduled Job 'Log Shipping Restore for
> (local).BPP_logshipping'(0x6DA834715FFBFD4C8DF2F9226CA343F)
> Status: Failed - Invoked on 2008-01-21 09:29:00 - Messae: The job failed.
> The job was invoked bye schedule (Schedule 1). The lst step to run was step
> 1 (Log Shipping Restore).
> In SQL enterpise, jobs, there is a Log shipping restore for local... in red.
> the files rtn in SQL Secundary is the same in SQL Primary.
> I don't find solution.
>