How can we help you today? How can we help you today?

Error restoring empty log

I am experiencing an issue with restoring log files for a relatively inactive database. The database gets updates 3-4 times a day and the rest of the hourly log files have minimal transactions.

This is an older log, but the same error is coming across. When we delete the offending file, the restore continues without error:
SQL Backup v7.3.0.57                                                                                                                                                                                                                                           
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Warning 170: No LSN information contained in file: 'LOG_(db)_2014092205.SQB'
Warning 170: Log files are not in sequence: 'LOG_(db)_2014092205.SQB' and 'LOG_(db)_2014092206.SQB'
Restoring (db) (transaction logs) from: 
  (path)(db)TransactionLogsLOG_(db)_2014092205.SQB
 
SQL Server error
 
SQL error 3013: SQL error 3013: RESTORE LOG is terminating abnormally.
SQL error 3254: SQL error 3254: The volume on device 'SQLBACKUP_9F133746-0E9B-4B18-A45C-4CB17CD76E9F' is empty.
 
SQL Backup exit code: 1100
SQL error code: 3254
theit8514
0

Comments

1 comment

Sort by
  • petey
    SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:Documents and SettingsAll UsersApplication DataRed GateSQL BackupLog<instance name> on Windows 2003 and older, and C:ProgramDataRed GateSQL BackupLog<instance name> on Windows Vista and newer.

    Could you please post the contents of the log file for the backup process that created the file 'LOG_(db)_2014092205.SQB'?

    Thanks.
    petey
    0

Add comment

Please sign in to leave a comment.