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

Article:TECH77754  |  Created: 2009-01-08  |  Updated: 2014-07-07  |  Article URL http://www.symantec.com/docs/TECH77754
Article Type
Technical Solution


Subject

Issue



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



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.

Supplemental Materials

SourceUMI
ValueV-79-65323-4326
Description

An error occurred on a query to database DBNAME.


SourceUMI
ValueV-79-65323-4326
Description

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.


SourceError Code
Value0xe0008492
Description

Database Query Failure. See the job log for details.
 


Legacy ID



338334


Article URL http://www.symantec.com/docs/TECH77754


Terms of use for this information are found in Legal Notices