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 |
Problem
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
|
|
| Source | Error Code |
| Value | 0xe0008492 |
| Description | Database Query Failure. See the job log for details. |
| Source | ETrack |
| Value | 1089134 |
| Description | SQL2005:X-64:Restore job of single database fails with incomplete log backup |
| Source | UMI |
| Value | V-79-57344-33938 |
Related Articles
Legacy ID
290543
Article URL http://www.symantec.com/docs/TECH53064
Terms of use for this information are found in Legal Notices
Thank you.