What are the challenges you face when working across database platforms? Take the survey
Options

Backup error - Warning: System error 87

ToehoToeho Posts: 73
edited October 13, 2007 9:23PM in SQL Backup Previous Versions
Recieved the following backup error durring our log shipping job and it broke the chain of logs.

Is there a possible way of using this log backup, I have tried the gui, cmd line, and the sqb converter with no luck.

Bad thing is if I cant use this file I have to put the full backup (150gb compresed) to tape and ship to the dr site and start log shipping all over, heres to hoping you have some magic.

Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: h:\backups\PRD_10122007_124502_LOG.sqb
Warning: System error 87(The parameter is incorrect)

Thread 0 error:
Error 620: Error writing to backup file(s).

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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)
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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,
  • Options
    peteypetey Posts: 2,358 New member
    I received your email. How large is the backup file?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    backup file is 20mb
Sign In or Register to comment.