IO Error for large DBs using ZIP/RAR formats

Silent compression for faster, smaller SQL Server backups

IO Error for large DBs using ZIP/RAR formats

Postby JReitter » Wed Oct 12, 2011 2:21 pm

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\\" 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\\" 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.
Posts: 29
Joined: Thu Apr 05, 2007 1:59 pm

Postby javen » Fri Oct 14, 2011 9:17 pm

We will need to see the HyperBac logs, we will contact
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Posts: 50
Joined: Mon May 24, 2010 11:10 pm

Return to SQL HyperBac 5

Who is online

Users browsing this forum: No registered users and 0 guests