SQL SERVER – OS Error 13 – The Data is Invalid OS Error 87 – The Parameter is Incorrect – Various Errors due to Faulty Media or Hardware

One of my clients contacted me to see if I can provide any help in doing data recovery. Since my expert area is performance tuning, I offered them quick 15-minute time to see what the errors are and whether I have some techniques to recover the data for invalid OS error 87.

SQL SERVER - OS Error 13 - The Data is Invalid OS Error 87 - The Parameter is Incorrect - Various Errors due to Faulty Media or Hardware hardware

Here was the situation:

  1. They were not able to restore from the backup.

Msg 3203, Level 16, State 1, Line 2
Read on “K:\SQLBackups\AuditDB_backup_2017_03_04_000038_1441415.bak” failed: 13(The data is invalid.)
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Solarwinds

The error: “The data is invalid” is more of an operating system way of telling that file is not in a good shape

  1. When I looked into the ERRORLOG I found failures as below.

Error: 18210, Severity: 16, State: 1.
BackupIoRequest::ReportIoError: read failure on backup device ‘ K:\SQLBackups\AuditDB_backup_2017_03_04_000038_1441415.bak’. Operating system error 87(The parameter is incorrect.).

The error: “The parameter is incorrect” is again of an operating system way of telling that file is not in a good condition.

  1. Another error in ERRORLOG

Error: 3266, Severity: 16, State: 1.
The backup data at the end of ” K:\SQLBackups\AuditDB_backup_2017_03_04_000038_1441415.bak” is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.

WORKAROUND/SOLUTION

All error explained above are very dangerous and a SQL expert may not be able to help much. There are data recovery companies who might help. So, your best bet at this point would be either to contact hardware related company or data recovery company to help. If you have some other good backup, go with that.

Do let me know if you have any other suggestions in the comment area for the ODS error.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – Unable to Add Server Name SQLAUTH-LISTENER to Transport Device NetBt_If4 Status 2 – Windows Cluster
Next Post
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication

Related Posts

1 Comment. Leave new

  • Hi Pinal,

    H r u.

    Could you please Help me for fixing the below issue. If we take full backup and it success for restore verifyonly WITH CHECKSUM is vaild but immediate if we take diff backup that diff backup is failing for Restore verifyonly

    Below is the Error Message:

    Msg 3242, Level 16, State 2, Line 1
    The file on device ‘K:\Backups\2019-Week15\Db_0007.diff’ is not a valid Microsoft Tape Format backup set.
    Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.

    Regards,
    Malli

    Reply

Leave a Reply

Menu