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

Restore fails with Nonrecoverable I/O error on file '???'

wpawpa Posts: 8
edited July 12, 2006 9:16AM in SQL Backup Previous Versions
I am using SQLBackup v to restore from a .sqb file on a network share. I don't have enough space to put the .sqb locally. Any ideas?


  • Options
    Found it! Someone had put disk compression on the disk used for the database files. Microsoft says SQLServer database files should not be compressed - leads to rrandom I/O errors. This would explain why we have been having other random I/O errors on that server for months!

Sign In or Register to comment.