Friday, February 24, 2012

Log shipping alerts

the "Log Shipping alert job-restore" job keeps showing a status of "failed"
,
however the databases are in sync. and yes I do have sp3;mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:

> mrdj - are there any entries in the system error log files that may point
to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:

> mrdj - are there any entries in the system error log files that may point
to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>

No comments:

Post a Comment