BackupIoRequest::ReportIoError: read failure on backup device 'C:\Ondemand\databasename.bak'. Operating system error 13(The data is invalid.).

Question

i am trying to take a backup with verification after backup complete and with include of checksum, still verification of backup failed and also restoration is also failing and when i pulled out the error log i got this error and i am unable to sort this in any manner. does anyone know how to resolve this issue.

i am using a sql server 2016 & 2019.

i have tried to restore the old backup files in new version also still the same error.

database is getting into restore status only.

even tryed to move the backup file to another server and restore from there also same issue, file is on read and data invalid issues is poping up.

Answer 1

Hi @Mahesh Mattapally,

The data is invalid.

Seems like the file has been corrupted, could you please try to back up a test database to the folder and restore to check if the disk is damaged or only the file is corrupted.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Are you using the BACKUP command, or are you using a third-party software? Something seems to be seriously wrong if you take backup which is not readable anywhere. Like your disk is munging some of the bytes. I would try a different backup destination, but if I were you, I would like to get away from this hardware as soon as possible.