SQL Error 4305

• 
  Could you please check the backup logs on the production server (Server A), for the correponding log backup file that generated error 4305? The default folder for the logs is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>.
  
  Were there any warnings recorded?
  
  Thanks.

  petey February 19, 2008 04:00

  - 0 +
• 
  Log on Server A
  (The Log Failed to Restore on Server B with the error code 4305)
  
  SQL Backup log file 5.2.0.2825
  2008/02/10 14:40:00: Backing up Cellular (transaction log) to:
  2008/02/10 14:40:00: \CellularLogs\LOG__Cellular_20080210_144000.sqb
  
  2008/02/10 14:40:00: BACKUP LOG [Cellular] TO DISK = 'D:\CellularLogs\LOG__Cellular_<DATETIME yyyymmdd_hhnnss>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 7, COPYTO = '\\192.168.110.48\CellularLogs', COMPRESSION = 1, THREADS = 1
  
  2008/02/10 14:40:06: Backup data size : 73.500 MB
  2008/02/10 14:40:06: Compressed data size: 21.210 MB
  2008/02/10 14:40:06: Compression rate : 71.14%
  
  Processed 8698 pages for database 'Cellular', file 'Cellular_Log' on file 1.
  BACKUP LOG successfully processed 8698 pages in 4.351 seconds (16.375 MB/sec).
  2008/02/10 14:40:07: Deleting old backup file: \CellularLogs\LOG__Cellular_20080203_144000.sqb
  2008/02/10 14:40:09: Copied \CellularLogs\LOG__Cellular_20080210_144000.sqb to \\192.168.110.48\CellularLogs\LOG__Cellular_20080210_144000.sqb.
  2008/02/10 14:40:09: SQL Backup process ended.
  
  
  This is the Latest Log On server A
  
  (The Log Failed to Restore on Server B with the error code 4305)
  
  SQL Backup log file 5.2.0.2825
  2008/02/10 18:40:00: Backing up Cellular (transaction log) to:
  2008/02/10 18:40:00: \CellularLogs\LOG__Cellular_20080210_184000.sqb
  
  2008/02/10 18:40:00: BACKUP LOG [Cellular] TO DISK = 'D:\CellularLogs\LOG__Cellular_<DATETIME yyyymmdd_hhnnss>.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 7, COPYTO = '\\192.168.110.48\CellularLogs', COMPRESSION = 1, THREADS = 1
  
  2008/02/10 18:40:31: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)
  2008/02/10 18:40:41: SQL error 3013: BACKUP LOG is terminating abnormally.
  2008/02/10 18:40:41: SQL error 3201: Cannot open backup device 'SQLBACKUP_E6A26A88-FFC3-4663-B1CC-858EA96F5A70'. Operating system error 0x80070002(The system cannot find the file specified.).
  2008/02/10 18:40:41:
  2008/02/10 18:40:41: Memory profile
  2008/02/10 18:40:41: Type Maximum Minimum Average Blk count Total
  2008/02/10 18:40:41:

  ---

  ---

  ---

  ---

  ---

  ---

  2008/02/10 18:40:41: Commit 68050944 4096 1168870 1546 1807073280
  2008/02/10 18:40:41: Reserve 2088960 4096 112132 311 34873344
  2008/02/10 18:40:41: Free 156958720 4096 1725827 177 305471488
  2008/02/10 18:40:41: Private 68050944 4096 1248368 1415 1766440960
  2008/02/10 18:40:41: Mapped 1060864 4096 111323 56 6234112
  2008/02/10 18:40:41: Image 24707072 4096 179459 386 69271552
  2008/02/10 18:40:41:
  2008/02/10 18:40:41: Warning 300: Backup failed. Retry attempt: 1
  2008/02/10 18:40:43: BACKUP LOG [Cellular] TO DISK = 'D:\CellularLogs\LOG__Cellular_20080210_184000.sqb' WITH NAME = 'Database (Cellular), 2008/02/10 18:40:00', DESCRIPTION = 'Backup on 2008/02/10 18:40:00 Server: CAPS Database: Cellular', INIT, ERASEFILES = 7, COPYTO = '\\192.168.110.48\CellularLogs', COMPRESSION = 1, THREADS = 1
  
  2008/02/10 18:40:49: Backup data size : 89.063 MB
  2008/02/10 18:40:49: Compressed data size: 28.612 MB
  2008/02/10 18:40:49: Compression rate : 67.87%
  
  Processed 11232 pages for database 'Cellular', file 'Cellular_Log' on file 1.
  BACKUP LOG successfully processed 11232 pages in 5.460 seconds (16.850 MB/sec).
  2008/02/10 18:40:49: Deleting old backup file: \CellularLogs\LOG__Cellular_20080203_183001.sqb
  2008/02/10 18:40:49: Deleting old backup file: \CellularLogs\LOG__Cellular_20080203_184000.sqb
  2008/02/10 18:40:53: Copied \CellularLogs\LOG__Cellular_20080210_184000.sqb to \\192.168.110.48\CellularLogs\LOG__Cellular_20080210_184000.sqb.

  RudiM February 19, 2008 05:21

  - 0 +
• 
  For the logs that failed to be restored, could you please run a RESTORE SQBHEADERONLY on that file, and the backup file prior to that? Does the 'Last LSN' value of the previous file match up to the 'First LSN' value of the file that failed to be restored?
  
  Thanks.

  petey February 20, 2008 04:19

  - 0 +
• 
  Hi
  Hope all is well.
  
  I read in one of the posts that SQL BackUp 5.3 sorts out a problem regarding to the LSN numbering. Will that sort out my problem? I am still having a lot of problems with my log restore. (SQL Error 4305) When the job runs on server B with the wild card for the log name
  
  DECLARE @exitcode int
  DECLARE @sqlerrorcode int
  exec master..sqlbackup N'-sql "RESTORE LOG [Cellular] FROM DISK = ''F:\CellularLogs\LOG__Cellular_*.sqb'' WITH STANDBY = ''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\UNDO_Cellular.DAT'', ERASEFILES = 7, FILEOPTIONS = 1, MOVETO = ''F:\CellularLogs\done\''"', @exitcode OUTPUT, @sqlerrorcode OUTPUT
  IF (@exitcode <>0) OR (@sqlerrorcode <> 0)
  BEGIN
  RAISERROR ('SQL Backup job failed with exitcode: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
  END
  
  the job wil fail with SQL error 4305
  
  But if I run the same job in SQL Query and spesify the log name the restore job will succeed...
  
  Thx
  Rudi

  RudiM October 07, 2008 03:59

  - 0 +

Add comment

Please sign in to leave a comment.