Error 775 Question

• 
  A SQL Backup backup file contains a header block, followed by the actual compressed/encrypted backup data. The header block contains, among other details, the LSN values of the backup data. These values are only written upon completion of the backup, when they are known.
  

  So when I get this error the .sqb is no good?

  The backup file is still usable, it is only the LSN details that are missing.
  

  And if it were a log backup that got the message, my chain has been broken?

  The backup file is still usable. What you will not be able to do now is to restore a sequence of log backups automatically e.g.
  

  EXEC master..sqlbackup '-sql "RESTORE LOGS AdventureWorks FROM DISK = [g:\backups\AdventureWorks_logs\*.sqb]"'
  

  as SQL Backup uses the LSN values to sort the backup files.
  
  If you want to find out which application is locking the backup file, you can do the following:
  
  - download Handle from Sysinternals
  - copy the executable file (handle.exe) to the folder where the SQL Backup Agent service (SQBCoreService.exe) is installed
  
  Now when SQL Backup encounters a file locking error, it will use Handle to try to identify the locking application.

  petey June 13, 2011 22:28

  - 0 +
• 
  Thanks for the reply. I'm sure it's the AV. It's ALWAYS the AV

  Randy Doub June 15, 2011 08:44

  - 0 +

Add comment

Please sign in to leave a comment.