Error: SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding. The following message is not a LiteSpeed 2005 message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE DATABASE is terminating abnormally.
The tail of the log for the database "database name" 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 may complete successfully with SQL SERVER 2000 but fail in SQL SERVER 2005. The database is in full recovery mode, but you haven't backed up the "tail of the log". The "tail of the log" are the transactions entered since the last time a backup completed.
You need to have a tail backup of the log file (depending on your version of sql).
If the database is damaged, for example, if the database does not start, a tail-log backup succeeds only if the log files are undamaged, the database is in a state that supports tail-log backups, and the database does not contain any bulk-logged changes.
From BooksOnline: BACKUP LOG database_name TO WITH CONTINUE_AFTER_ERROR
Even with a corrupted (suspect status) database you will be able to backup the tail of the log.
WORKAROUND:
SQL Server Native:
Example: BACKUP LOG db_name TO DISK = 'C:\TESTS\db_name_log.trn' WITH INIT, NO_TRUNCATE;
LiteSpeed:
EXEC master..xp_backup_database @database='northwind', @filename='e:\MSSQL\Backup\NW_tail.bak', @with='NO_TRUNCATE'
Requirement of backing up tail of the log for the database can be overridden by using the REPLACE or WITH STOPAT command. WITH REPLACE or WITH STOPAT clauses may be used with the LiteSpeed xp_restore commands.
CAUTION: The REPLACE option overrides several important safety checks that restore normally performs. The overridden checks are as follows:
Restore Full backup (NO RECOVERY option) + restore all Log backups to point of failure (NO RECOVERY option) + restore tail backup (RECOVERY option) -> you are able to restore the database to the last point of failure.
For additional information, see: http://msdn2.microsoft.com/en-us/library/ms179314.aspx , http://msdn.microsoft.com/en-us/library/ms191315(SQL.90).aspx or Books Online
Also see, http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&tid=f4187089-40a8-420b-b912-77f1b5a79834&p=1
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center