Log Shipping Monitoring

When I execute the following SP:
EXEC msdb..sp_get_log_shipping_monitor_info @.secondary_database_name =
'pubs%'
I get some information regarding [copy_delta] and [load_delta]
I'm pretty sure copy_delta are there number of files copied over from the
source server. I don't know what the load_delta means though. Sometimes it
shows a low number then sometimes it shows a high number. I intially
thought it was the number of transaction logs that got loaded into the
standby server but when that number hits 69 and it only copied 3, it doesn't
make sense. There is also no documenation on BOL or microsoft's web site on
this.
Regards,
Tim
Hi Tim,
Based on my research, load_delta indicates the the difference in minutes
between the last updated date of the last backup file and the last updated
date of the last loaded file. In ths code of the sp_log_shipping_in_sync
stored procedure, which is called in sp_get_log_shipping_monitor_info, you
may see the following codes.
SELECT @.delta = DATEDIFF (mi, @.last_updated, @.compare_with)
Also, the @.last_updated is @.restoredt, which is got from the following
codes.
EXECUTE @.rv = sp_log_shipping_get_date_from_file @._primary_database_name,
@.last_backup_filename, @.backupdt OUTPUT
IF (@.rv <> 0)
SElECT @.backupdt = @.last_backup_last_updated
the@.compare_with is @.backupdt, which is got form the followig codes.
EXECUTE @.rv = sp_log_shipping_get_date_from_file @._primary_database_name,
@.last_loaded_filename, @.restoredt OUTPUT
IF (@.rv <> 0)
SElECT @.restoredt = @.last_loaded_last_updated
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
|||Thanks,
this is exactly what I am looking for.
Regards,
Tim
""Yuan Shao"" <v-yshao@.online.microsoft.com> wrote in message
news:PIofhxLNEHA.928@.cpmsftngxa10.phx.gbl...
> Hi Tim,
> Based on my research, load_delta indicates the the difference in minutes
> between the last updated date of the last backup file and the last
updated
> date of the last loaded file. In ths code of the sp_log_shipping_in_sync
> stored procedure, which is called in sp_get_log_shipping_monitor_info, you
> may see the following codes.
> SELECT @.delta = DATEDIFF (mi, @.last_updated, @.compare_with)
> Also, the @.last_updated is @.restoredt, which is got from the following
> codes.
> EXECUTE @.rv = sp_log_shipping_get_date_from_file @._primary_database_name,
> @.last_backup_filename, @.backupdt OUTPUT
> IF (@.rv <> 0)
> SElECT @.backupdt = @.last_backup_last_updated
> the@.compare_with is @.backupdt, which is got form the followig codes.
> EXECUTE @.rv = sp_log_shipping_get_date_from_file @._primary_database_name,
> @.last_loaded_filename, @.restoredt OUTPUT
> IF (@.rv <> 0)
> SElECT @.restoredt = @.last_loaded_last_updated
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
>
>