Restore of SQL 2005 database fails with the error message "The tail of the log for the database "TEST1" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log."

Article:TECH53064  |  Created: 2007-01-10  |  Updated: 2012-02-02  |  Article URL http://www.symantec.com/docs/TECH53064
Article Type
Technical Solution


Issue



Restore of SQL 2005 database fails with the error message "The tail of the log for the database "TEST1" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log."


Error



Restore job log shows:-

The tail of the log for the database "TEST1" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

Restore of a user created SQL 2005 database fails with the error messages "Final error: 0xe0008492 - Database Query Failure" and "An error occurred on a query to the database DATABASENAME". The backup job is however successful.

0xe0008492 - Database Query Failure V-79-57344-33938


Cause



This issue occurs if the option "Overwrite the existing database" is not selected under Restore Job Properties | Settings | Microsoft SQL.
If the user is trying to overwrite a SQL 2005 database that contains unprotected data in its log, the overwrite database option must be used for the restore job to work. This is by design. It is a safety feature of SQL 2005 to prevent data loss.

 


Solution



Select the option "Overwrite the existing database" under Restore Job Properties | Settings | Microsoft SQL and run the restore job again.


 

Supplemental Materials

SourceError Code
Value0xe0008492
Description

Database Query Failure. See the job log for details.


SourceETrack
Value1089134
Description

SQL2005:X-64:Restore job of single database fails with incomplete log backup


SourceUMI
ValueV-79-57344-33938


Legacy ID



290543


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


Terms of use for this information are found in Legal Notices