<div>
I noticed that too, the job was since then recreated and history of the new restore jobs on the sec server shows the restore job gets done. Does SQL get confused here?
</div>


I noticed that too, the job was since then recreated and history of the new restore jobs on the sec server shows the restore job gets done. Does SQL get confused here?

<div>
<div class="content wysiwyg-content">
I'm getting this error<br />
<br />
Event Type: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Error<br />
Event Source: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MSSQLSERVER<br />
Event Category: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(2)<br />
Event ID: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14421<br />
Date: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5/10/2013<br />
Time: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12:10:00 PM<br />
User: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NT AUTHORITY\NETWORK SERVICE<br />
Computer: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;COMPANY-WEB-03<br />
Description:<br />
The log shipping secondary database COMPANY-WEB-03.COMPANY_New<wbr /> has restore threshold of 45 minutes and is out of sync. No restore was performed for 2059157 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.<br />
<br />
Log shipping was setup ion this server with the same settings before and I assume it was working. Now is not working.<br />
<br />
Where do I start looking. <br />
<br />
TRN Files get shipped over to the other host, all SQL services run on both hosts. It's SQl 2005 Standard
</div>
</div>


I'm getting this error

Event Type:	Error
Event Source:	MSSQLSERVER
Event Category:	(2)
Event ID:	14421
Date:		5/10/2013
Time:		12:10:00 PM
User:		NT AUTHORITY\NETWORK SERVICE
Computer:	COMPANY-WEB-03
Description:
The log shipping secondary database COMPANY-WEB-03.COMPANY_New has restore threshold of 45 minutes and is out of sync. No restore was performed for 2059157 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.

Log shipping was setup ion this server with the same settings before and I assume it was working. Now is not working.

Where do I start looking. 

TRN Files get shipped over to the other host, all SQL services run on both hosts. It's SQl 2005 Standard

The log shipping secondary database COMPANY-WEB-03.COMPANY_New has restore threshold of 45 minutes and is out of sync.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).