Red Gate forums :: View topic - IO Error for large DBs using ZIP/RAR formats
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL HyperBac 5
SQL HyperBac 5 forum

IO Error for large DBs using ZIP/RAR formats

Search in SQL HyperBac 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JReitter



Joined: 05 Apr 2007
Posts: 25

PostPosted: Wed Oct 12, 2011 3:21 pm    Post subject: IO Error for large DBs using ZIP/RAR formats Reply with quote

We are in the process of evaluating the SQL HyperBac (version 5.4.1.5?) 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.
Back to top
View user's profile Send private message
javen



Joined: 25 May 2010
Posts: 50

PostPosted: Fri Oct 14, 2011 10:17 pm    Post subject: Reply with quote

We will need to see the HyperBac logs, we will contact
_________________
Jeffrey Aven
Product Management - HyperBac Technologies
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group