Error during SQL restore: The log in this backup set terminates at LSN ;sequence number; which is too early to apply to the database

Problem

Error during SQL restore: The log in this backup set terminates at LSN , which is too early to apply to the database. A more recent log backup that includes LSN can be restored.

Error Message

0xe0008492 - Database Query Failure. See the job log for details
 
V-79-65323-4326 - An error occurred on a query to database DBNAME.
 
V-79-65323-4326 - The log in this backup set terminates at LSN <Sequence Number>, which is too early to apply to the database. A more recent log backup that includes LSN <Sequence Number> can be restored.
 

Cause

This error is caused by SQL Log backups being selected for the restore that are older than the SQL Full backup. 

Solution

 Deselect the SQL Log backups that are older then the full backup of the SQL databases then run the restore again.
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)