Competition: What’s your favorite Redgate tool? Enter now.

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 3.2.0.1 to restore from a .sqb file on a network share. I don't have enough space to put the .sqb locally. Any ideas?

Comments

  • 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.