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

IO Error for large DBs using ZIP/RAR formats

DBNewbie_2007DBNewbie_2007 Posts: 47 Bronze 3
edited October 14, 2011 5:17PM in SQL HyperBac 5
We are in the process of evaluating the SQL HyperBac (version product. So far, when we backup smaller databases (anything less than 1 Gbyte in total size), the back to the "zip" format works great.

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.


Sign In or Register to comment.