IO Error for large DBs using ZIP/RAR formats
However, when trying to backup our larger databases (200 GBytes to 950 GBytes), we receive the following error(s):
Msg 3202, Level 16, State 2, Line 1
Write on "J:\Backups\DataCap\OneLargeDB_backup_20111012.zip" failed: 31(A device attached to the system is not functioning.)
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "J:\Backups\DataCap\OneLargeDB_backup_20111012.zip:" 31(A device attached to the system is not functioning.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally
Depending on the size of the database (> 2 GB or greater than 100 GB), the smaller DBs will get up to 40% complete (using STATS = 10 option) before failing.
Some items of note:
1) Normal backups using
BACKUP DATABASE [OneLargeDB] TO DISK = 'J:\Backups\DataCap\OneLargeDB_backup_20111012.bak' WITH RETAINDAYS = 14, INIT, STATS = 10, NAME = N'OneLargeDB_backup_20111012'
appear to work fine.
2) hbc, hbc2 format also appear to work fine.
3) We tried this on the same server to two different drives, one attached directly to the server (J: drive, in this case), one attached to a dedicated network card with iSCSI protocol has the same error (Drobo storage system). This is the unit we typically put all of our backups on.
4) Server details:
SQL Server (32-bit), 9.00.4273.00 SP3 Standard Edition
OS: Windows 2008 Enterprise (32-bit)
HW: Dell PE2950
Intel Xeon X5470 @3.33Ghz (2 processors)
32GB RAM, 32-bit OS
5) 7zip (32-bit, version 4.63) has been installed on the system. We have had lots of success in zipping and unzipping very large (100GB +) files using this software.