MSSQLSERVER_14420

New: 17 July 2006

Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1281.60

Event ID

14420

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

SQLErrorNum14420

Message Text

The log shipping primary database %s.%s has backup threshold of %d minutes and has not performed a backup log operation for %d minutes. Check agent log and logshipping monitor information.

Explanation

Log shipping is out of synchronization beyond the backup threshold. The backup threshold is the number of minutes that are allowed to elapse between log-shipping backup jobs before an alert is generated. This message does not necessarily indicate a problem with log shipping. Instead, this message might indicate one of the following problems:

  • The backup job is not running. Possible causes for this include the following: the SQL Server Agent service on the primary server instance is not running, the job is disabled, or the job's schedule has been changed.
  • The backup job is failing. Possible causes for this include the following: the backup folder path is not valid, the disk is full, or any other reason that the BACKUP statement could fail.

User Action

To troubleshoot this message:

  • Make sure that the SQL Server Agent service is running for the primary server instance and that the backup job for this primary database is enabled and is scheduled to run at the appropriate frequency.

  • The backup job on the primary server might be failing. In this case, examine the job history for the backup job to look for the cause.

  • The log shipping backup job, which runs on the primary server instance, might not be able to connect to the monitor server instance to update the log_shipping_monitor_primary table. This could be caused by an authentication problem between the monitor server instance and the primary server instance.

  • The backup alert threshold might have an incorrect value. Ideally, this value is set to at least three times the frequency of the backup job. If you change the frequency of the backup job after log shipping is configured and functional, you must update the value of the backup alert threshold accordingly.

  • When the monitor server instance goes offline and then comes back online, the log_shipping_monitor_primary table is not updated with the current values before the alert message job runs. To update the monitor tables with the latest data for the primary database, run sp_refresh_log_shipping_monitor on the primary server instance.

  • On the primary or monitor server instance, the date or time is incorrect. This may also generate alert messages. Possibly the system date or time was modified on the one of them.

    Note

    Different time zones for the two server instances should not cause a problem.

See Also

Other Resources

log_shipping_monitor_primary (Transact-SQL)
Monitoring Log Shipping
sp_help_log_shipping_monitor_primary (Transact-SQL)
sp_refresh_log_shipping_monitor (Transact-SQL)
Understanding Log Shipping

Help and Information

Getting SQL Server 2005 Assistance