Backup error - Warning: System error 87

• 
  In the backup where this error occurred, did SQL Server report a successful backup message i.e. the message that states the number of pages that were backed up?
  
  Thanks.

  petey October 13, 2007 09:11

  - 0 +
• 
  Here is the info from the backupset table - it appears that sql thinks the backup was good.
  
  backup_set_id name description user_name first_lsn last_lsn checkpoint_lsn database_backup_lsn database_creation_date backup_start_date backup_finish_date type backup_size

  ---

  ---

  ---

  ---

  ---

  ---

  ---

  ---

  ---

  ---

  ---

  ----

  ---

  17430 Database (PRD), 10/12/2007 12:45:02 PM Backup on 10/12/2007 12:45:02 PM Server: SWCS46CI Database: PRD NT AUTHORITY\SYSTEM 221616000013121100001 221616000024085800001 221616000022630000001 221612000010702100001 2007-09-09 03:55:03.000 2007-10-12 12:45:02.000 2007-10-12 12:45:04.000 L 56754176
  
  (1 row(s) affected)

  Toeho October 13, 2007 10:39

  - 0 +
• 
  If that's the case, I don't think the log file is recoverable. If the file isn't too large, you can send me a copy and I can determine if the portion that was failed to be written was a non-critical section.
  
  Could you please also tell me the backup command that was used? I would like to know the options and settings used for the backup.
  
  Thanks.

  petey October 13, 2007 11:33

  - 0 +
• 
  sent you an email with the backup command - unable to send the backup file because of size restrictions on our email system - is there a way I can upload the file to you??
  
  Thanks,

  Toeho October 13, 2007 18:37

  - 0 +
• 
  I received your email. How large is the backup file?

  petey October 13, 2007 19:41

  - 0 +
• 
  backup file is 20mb

  Toeho October 13, 2007 21:23

  - 0 +

Add comment

Please sign in to leave a comment.