Log Shipping

12 Aug 2005 8:50 PM

Ed

Hi,
When I create the log shipping using M. Plan, there are two jobs created
called "Log Shipping Alert Job - Backup", "Log Shipping Alert Job - Retore".
What are they actually doing?

Thanks

Ed

12 Aug 2005 9:23 PM

Stu

When you specified how often you wanted the logs backed up and how
often you wanted to restore them, SQL Server used these values to build
these jobs. The ybasically check to see how far out of sync your two
databases are, and if they exceed the valeus specifed, then they alert
you.

HTH,
Stu

12 Aug 2005 10:02 PM

Ed

That is what I thought too,
Backup - for Backup Alert
Restore - for out-of-sync Alert

However, when I right click the Log Shipping Monitor, I can choose disable
those two Alert, after I disable one/two/both, the actaul job itself is still
running. I am still wondering what are the disable doing under the Monitor.

Thanks

Edmund

Show quote

"Stu" wrote:

> When you specified how often you wanted the logs backed up and how
> often you wanted to restore them, SQL Server used these values to build
> these jobs. The ybasically check to see how far out of sync your two
> databases are, and if they exceed the valeus specifed, then they alert
> you.
>
> HTH,
> Stu
>
>